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

>>-oncheck----------------------+----------------------+------->   
                                '- -pw-+------------+--'
                                       '--filename--'
>--+- -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 HCL OneDB™ 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 HCL OneDB 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 HCL OneDB 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 HCL OneDB 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 HCL OneDB 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.

Note:

The -pw option is required only when the Storage space encryption feature is enabled and no stash file is in use. Supply an optional path to a file containing the keystore password, otherwise oncheck will prompt for a password before displaying the requested page(s).

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