Re: How to check when database is getting full?

> If you have dynamic server you can query he sysmaster database. One table to check out is the syschktab table with the following query: select chknum, (nfree/chksize) percent_free from syschktab Output looks as follows: chknum percent_free 1 0.685056000000000 2 0.603256835937500 ... ... > Is there any way -- preferably with an SQL command -- to know how much > space remains in a database space (other than looking with tbmonitor). > If there's no SQL command, is there some ESQL function? If not, is > there some Informix utility that can be run with system()? > > Thanks in advance, Mark > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com