Re: How to retrieve DBSPACE where a database is stored?

Would "oncheck -pe" help you with this? You can parse the output and see how much space your database or table is using. Hope this information helps. Brice Avila Minneapolis, Minnesota Rupan3rd <rupan.nospam.3rd@hotmail.com> wrote in message news:<3EED8501.801@hotmail.com>... > Hi there! > > How can I query SYSMASTER (or SYSUTILS?) database in order to retrieve > the information about what DBSPACE is containing my application's > database? And also, what CHUNKS do compose a DBSPACE and how much > are they filled of data? > > My aim is to make a script to control space available in the dbspace > where application database is stored. This should be dynamic, because > I don't manage only one single installation... :) > > Can anyone help? > > Thanx in advance > Alessandro > > > > > > > orc@taz:/> uname -a > SunOS taz 5.8 Generic_108528-12 sun4u sparc SUNW,UltraAX-i2 > orc@taz:/> onstat -d > > Informix Dynamic Server 2000 Version 9.21.UC5 -- On-Line -- Up 7 > days 01:01:20 -- 253952 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 1810b7d0 1 0x1 1 2 N informix rootdbs > 18d785d0 2 0x2001 2 1 N T informix tmp_dbs > 18d78718 3 0x1 3 1 N informix log_dbs > 3 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 1810b918 1 1 0 1000000 959570 PO- > /dev/informix_root1 > 18d78180 2 2 0 100000 99947 PO- /dev/informix_tmp > 18d782f0 3 3 100000 150000 124947 PO- /dev/informix_tmp > 18d78460 4 1 0 1000000 415044 PO- > /dev/informix_root2 > 4 active, 2047 maximum