RE: Database Size

Posted in 2000

Vinod Bhansali — Thu, 18 May 2000 17:33:47 GMT — source: Informix-list mailing list archive (1991-1998)

Try this to get only Databases in the output : select dbsname Database, sum(ti_nptotal) Allocated, sum(ti_npused) PagesUsed from systabnames,systabinfo where partnum=ti_partnum and tabname not matches "TBLSpace" group by 1 order by 1 Vinod Bhansali >From: "Murray Wood" <murray@quanta.co.nz> >Reply-To: <murray@quanta.co.nz> >To: "'kakkar'" <sudhakark@hotmail.com>, <informix-list@iiug.org> >CC: <sudhakark@att.net> >Subject: RE: Database Size >Date: Thu, 18 May 2000 11:31:12 +1200 > >Try this: > >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-informix-list@iiug.iiug.org >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of kakkar >Sent: Thursday, May 18, 2000 2:28 AM >To: informix-list@iiug.org >Subject: Database Size > > >Hi, > >Could you please let me know how to find out >how much MB is used by each database in a given dbspace. >Please email me at sudhakark@att.net > >thank you >-suda > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com