oncheck -pp and -pP: Display the contents of a logical page

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-oncheck------------------------------------------------------>

>--+- -pp--+-database--:--+--------+--table--+--------------+--rowid-+-+-><
   |       |              '-owner.-'         +-,--frag_dbs--+        | |   
   |       |                                 '-%--frag_part-'        | |   
   |       '-tblspacenum--logical pagenum----------------------------' |   
   '- -pP--chunknum--logical pagenum-----------------------------------'   

Element Purpose Key Considerations
database Specifies the name of a database that you want to check for consistency Syntax must conform to the Identifier segment; see IBM® Informix Guide to SQL: Syntax.
chunknum Specifies a decimal value that you use to indicate a particular chunk Value must be an unsigned integer greater than 0. Chunk must exist.
frag_dbs Specifies the name of a dbspace that contains a fragment you want to check for consistency Dbspace must exist and contain the fragment that you want to check for consistency.

Syntax must conform to the Identifier segment; see IBM Informix Guide to SQL: Syntax.

frag_part Specifies the partition name of the fragment to be checked. This is useful in cases where more than one fragment of a table was created in the same dbspace. For fragmented tables or an index that use expression-based or round-robin distribution schemes, you can create multiple partitions, which are collections of pages for a table or index, within a single dbspace. This partition is referred to as a fragment partition or fragpart.
logical pagenum Specifies an integer value that you use to indicate a particular page in a tblspace

Value can be expressed as an unsigned integer or hexadecimal that begins with 0x identifier.

Value must be an unsigned integer between 0 and 16,777,215, inclusive.
owner Specifies the owner of a table You must specify the current owner of the table.

Syntax must conform to the Owner Name segment; see IBM Informix Guide to SQL: Syntax.

rowid Identifies the rowid of the row whose contents you want to display. The rowid is displayed as part of oncheck -pD output Value must be an unsigned integer between 0 and 4,277,659,295, inclusive.

Value can be expressed as an unsigned integer or hexadecimal that begins with 0x identifier.

table Specifies the name of the table that you want to check for consistency Table exists when you execute the utility.

Syntax must conform to the Table Name segment; see IBM Informix Guide to SQL: Syntax.

tblspacenum Identifies the tblspace whose contents you want to display Value must be an unsigned integer between 0 and 208,666,624, inclusive.

Value can be expressed as an unsigned integer or hexadecimal that begins with 0x identifier.

The -pp option has the following syntax variations:
Invocation Explanation
oncheck -pp tblspc lpn <pages> Displays the contents of a logical page using a tblspace 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 tblspace number and logical page number.
oncheck -pp database:table rowid Displays the contents of a logical page using a database name, table name, and the 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

Copyright© 2018 HCL Technologies Limited