Re: dbspace stat

John H. Frantz wrote: > > oncheck -pT takes some time for larger tables which suggests to me that> it scans the table rather than simply querying the sysmaster tables. It > would seem that the current number of pages used in a table can't be > obtained through the sysmaster tables. > > However, I have noticed on occasion a *decrease* in ti_npused for a > given table. Could it be that ti_npused is in fact set to a currently > correct value under certain conditions? Here are some candidate > conditions: > > - Update statistics (nope, tested that). > - Reboot of the database engine (nope, tested that). > - Version upgrade of the database engine. > > Maybe someone from Informix could say. [Previous comments SNIPPED] Check out my printfreeB.ec utility in utils2_ak in the IIUG Software Repository, it does basically what oncheck -pT does and the counts it gets from walking the chain of bitmap pages almost always corresponds to the count in npused so I suspect that it is maintained live. Art S. Kagel