Display the Contents of a Logical Page with -pp and -pP

Home | Previous Page | Next Page Administrative Utilities > The oncheck Utility >

Display the Contents of a Logical Page with -pp and -pP

The -pp option has the following syntax variations:

Invocation	Explanation
oncheck -pp tblspc lpn <pages>	Displays the contents of a logical page using a tablespace number and logical page number. You can also specify an optional parameter specifying the number of pages to be printed.
oncheck -pp tblspc lpn -h	Displays only the header of a logical page using a tablespace number and logical page number.
oncheck -pp database:table rowid	Displays the contents of a logical page using a database name, table name, and an Informix internal rowid. You can obtain this internal rowid with the oncheck -pD command. This internal rowid is not the serial rowid that is assigned in tables created with the CREATE TABLE tabname WITH ROWIDS statement. For more information, see Definition of Rowid

The page contents appear in ASCII format. The display also includes the number of slot-table entries on the page. The following example shows different invocations of the oncheck -pp command:

oncheck -pp stores_demo:orders 0x211  # database:owner.table,   # fragment rowid
oncheck -pp stores_demo:informix.customer,frag_dbspce1 0x211
oncheck -pp 0x100000a 25 # specify the tblspace number and # logical page number

The -pP option provides the following syntax variations:

Invocation	Explanation
oncheck -pP chunk# offset pages	Displays the contents of a logical page using a chunk number and an offset. You can also specify an optional parameter specifying the number of pages to be printed.
oncheck -pP chunk# offset -h	Displays only the header of a logical page using a chunk number and an offset.

Note:

The output for chunk page displays both the start and the length fields in decimal format.

The following example shows typical output using the onstat -pP command:

oncheck -pP 1 5 2
addr         stamp         nslots         flag      type         frptr      frcnt      next      prev      stamp
100005         250181         2         1000      ROOTRSV         320      1716      0      0      250181
slot      ptr      len      flg
...
addr         stamp         nslots         flag      type         frptr      frcnt      next      prev      stamp
100005   6      250182         2         1000      ROOTRSV         128      1908      0      0      250182
slot      ptr      len      flg
1      24      56      0
2      80      48        0