How to retrieve DBSPACE where a database is stored?
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