Re: Database Size

Posted in 1998

Dragi Raos — Wed, 23 Dec 1998 20:27:28 +0100 — source: Informix-list mailing list archive (1991-1998)

Art S. Kagel wrote: > [...] > > 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 Art, does that mean that Informix7 reports total number of pages allocated in npused, not just data pages as I5 used to? Gee, I can stop using oncheck -p for that purpose... Dragi "Bonzi" Raos