Re: Chunk really full??? Puzzling . . .

} ... But the extents are }still allocated for the table and not shown as being free even though }rows have been deleted from the table. If this is the case, how does }one find out the "real" free space in a chunk? >>The "onstat -d" reports free pages which are not assigned to an extent. >>Your display shows that no space exists for additional extents. >>It does NOT mean that all extents in this dbspace are full. >>Use the "oncheck -pt <database>:<table-name>" command or query the >>corresponding SMI tables to determine how full your fragments are. Check the SMI table sysptnhdr in the sysmaster database joining sysptnhdr.partnum to sysfragments.partn and joining sysfragments.tabid to yourdb:systables.tabid. Look at the columns nptotal and npused. nptotal is the total amount of disk allocated to your table (fragment), while npused is the amount actually being used. The difference is the amount allocated, but still free for use. Bruce Farwell Spartan Stores, Inc. Grand Rapids, MI