RE: database size

Posted in 2000

Murray Wood — Thu, 7 Sep 2000 10:30:04 +1200 — source: Informix-list mailing list archive (1991-1998)

Hacked from something similar on the sysmaster database... select dbsname, sum(ti_nptotal) Allocated, sum(ti_npused) Used from systabnames, systabinfo where partnum = ti_partnum order by 1 group by 1 MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of anne Sent: Thursday, September 07, 2000 8:14 AM To: informix-list@iiug.org Subject: database size I am running informix version 7.24. Is there a way I can find out the size of a database? I have several databases and am running out of room. This would help me decide which to delete. Thank you Anne

↪ replying to Murray Wood

Tony Flaherty — Thu, 7 Sep 2000 14:19:37 +0100 — source: Informix-list mailing list archive (1991-1998)

Murray Wood wrote in message <8p6he6$ct7$1@news.xmission.com>... > >Hacked from something similar on the sysmaster database... > >select dbsname, sum(ti_nptotal) Allocated, sum(ti_npused) Used >from systabnames, systabinfo >where partnum = ti_partnum >order by 1 >group by 1> >MW > >-----Original Message----- >From: owner-informix-list@iiug.iiug.org >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of anne >Sent: Thursday, September 07, 2000 8:14 AM >To: informix-list@iiug.org >Subject: database size > > >I am running informix version 7.24. Is there a way I can >find out the size of a database? I have several databases and am >running out of room. This would help me decide which to delete. >Thank you >Anne Why not delete them all, that would give you loads of space ;o) -- Tony Flaherty Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! MFS Ltd.