Display Tblspaces for a Table or Fragment with -pt and -pT

The -pt option prints a tblspace report for a given table or fragment whose name and database you specify when you execute oncheck at the command line. The report contains general allocation information including the maximum row size, the number of keys, the number of extents, their sizes, the pages allocated and used per extent, the current serial value, and the date that the table was created. The -pt output prints the pagesize of the tablespace, the number of pages (allocated, used and data) in terms of logical pages. The Extents fields list the physical address for the tblspace tblspace entry for the table and the address of the first page of the first extent. The extent list shows the number of logical as well as physical pages in every extent. If you do not specify a table, the option displays this information for all tables in the database.

The -pT option prints the same information as the -pt option. In addition, the -pT option displays index-specific information and page-allocation information by page type (for dbspaces).

Output for both -pt and -pT contains listings for Number of pages used. The value shown in the output for this field is never decremented because the disk space allocated to a tblspace as part of an extent remains dedicated to that extent even after you free space by deleting rows. For an accurate count of the number of pages currently used, refer to the detailed information on tblspace use (organized by page type) that the -pT option provides. The following example shows a typical oncheck -pT command:

oncheck -pT stores_demo:customer

The following example shows an example of output of the oncheck -pt command:

TBLspace Report for testdb:tab1

Physical Address               2:10
Creation date                  10/07/2004 17:01:16
TBLspace Flags                 801        Page Locking
                                              TBLspace use 4 bit bit-maps
Maximum row size               14        
Number of special columns      0         
Number of keys                 0         
Number of extents              1         
Current serial value           1         
Pagesize (k)                   4         
First extent size              4         
Next extent size               4         
Number of pages allocated      340       
Number of pages used           337       
Number of data pages           336       
Number of rows                 75806     
Partition partnum              2097154   
Partition lockid               2097154   

Extents                       
       Logical Page     Physical Page        Size Physical Pages
                 0             2:106         340        680

For more examples of using oncheck -pt and -pT, see managing disk space in the IBM Informix Administrator's Guide and the IBM Informix Performance Guide.