oncheck -pp and -pP: Display the contents of a logical page
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. |
| 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