Re: Database size

Kutts Mike wrote: > 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 ? It's not exactly standard, but how about using the sysmaster database: select systabnames.dbsname, sum(te_size) from systabextents,systabnames where systabextents.te_partnum = systabnames.partnum group by 1 This will tell you how many pages are allocated (not necessarily used) by each database in your system. Filter on systabnames.dbsname if you only want one. June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (peanut)