RE: [ifxmaillist] SQL stmt. for computing the size of a database

Posted in 2000

Murray Wood — Mon, 1 May 2000 11:01:13 +1200 — source: Informix-list mailing list archive (1991-1998)

One I use: dbaccess sysmaster <<! select dbsname Database,sum(ti_nptotal) Allocated ,sum(ti_npused) PagesUsed from systabnames,systabinfo where partnum=ti_partnum group by 1 order by 1 ! MW -----Original Message----- From: owner-ifxmaillist@quanta.co.nz [mailto:owner-ifxmaillist@quanta.co.nz]On Behalf Of Rajiv P Jhaveri Sent: Saturday, April 29, 2000 2:28 AM To: informix-list@iiug.org Subject: [ifxmaillist] SQL stmt. for computing the size of a database Hi, Is there a sql stmt. that will query the sysmaster database to get the size of a database ? I am interested in the sum of data pages + index pages. (i.e pages allocated but not free). I am sure this info. can be obtained from the onchek output but want to use that as a last resort. Thanks. -- Rajiv Jhaveri rajivp@qsun.mt.att.com