Re: Database Size

Kutts Mike wrote: > > Hi Gurus, > > onstat -d shows the space left out in each chunk.> But I would like to know how much space is ocuppied by each database > in that particular chunk > > Thanks again > > With warm regards > Mike > > > >Sean Kelsey wrote: > >onstat -d or -D> > >displays each dbspace and the amount of free space >left. > > Kutts Mike wrote in message <75q727$fci$1@news.xmission.com>... > > > > Hi Admins, > > > >I have three database is one chunk.(Informix 7.30UC6X1) > >I would like to know how much space is occupied by each database. > > > >Is there any standard command in Informix ? No there is not, but there was a question yesterday about how many extents live in each chunk by table. I responded with an SMI query and later someone else corrected a typo there and enhanced the query to provide additional information. You can use the same query, with the addition of the databasename and report SUM(npused) instead of COUNT(*). Search the IIUG archive of this group for messages in the last 2 days with SMI in the subject. Art S. Kagel