SQL stmt. for computing the size of a database

Posted in 2000

Rajiv P Jhaveri — Fri, 28 Apr 2000 10:28:06 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Rajiv P Jhaveri

Rudy Fernandes — Mon, 01 May 2000 12:56:30 -0400 — source: Informix-list mailing list archive (1991-1998)

The following gives you the total allocated to a database : select sum(size) from sysextents where dbsname = '<dbname>' Rudy Rajiv P Jhaveri wrote: > 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 >