oncheck -pk, -pK, -pl, -pL: Display index information

Read syntax diagramSkip visual syntax diagram
Syntax:

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

>----+- -pk-+--+---+--database--+---------------------------------------+---><
     +- -pK-+  '-x-'            '-:--+--------+--table--+-------------+-'     
     +- -pl-+                        '-owner.-'         '-#index_name-'       
     '- -pL-'                                                                 

The -pk option performs the same checks as the -ci option and in addition, displays the key values for all indexes on the specified table as it checks them.

The -pK option performs the same checks as the -cI option and in addition, displays the key values and rowids as it checks them.

The -pl option performs the same checks as the -ci option and displays the key values, but checks only leaf-node index pages. It ignores the root and branch-node pages.

The -pL option performs the same checks as the -cI option and displays the key values and rowids, but checks only leaf-node index pages. It ignores the root and branch-node pages.

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 Informix® Guide to SQL: Syntax.
index_name Specifies the name of the index that you want to check for consistency Index must exist on table and in database specified.

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

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 Informix Guide to SQL: Syntax.

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 Informix Guide to SQL: Syntax.

-x Places a shared lock on the table when you check and print an index For complete information, see Turn On Locking with -x.

If any of the oncheck options detect inconsistencies, you are prompted for confirmation to repair the problem index. If you specify the -y (yes) option, indexes are automatically repaired. If you specify the -n (no) option, the problem is reported but not repaired; no prompting occurs.

The following example displays information about all indexes on the customer table:
oncheck -pl -n stores_demo:customer
The following example displays information about the index zip_ix, which was created on the customer table:
oncheck -pl -n stores_demo:customer#zip_ix

By default, the database server does not place a shared lock on the table when you check an index with the oncheck -pk, -pK, -pl, or -pL options unless the table uses page locking. For absolute assurance of a complete index check, you can execute oncheck –pk, oncheck -pK , oncheck -pl , or oncheck -pL with the -x option. With the -x option, oncheck places a shared lock on the table, and no other users can perform updates, inserts, or deletes until the check has completed. For more information on using the -x option, Turn On Locking with -x.

For more information on oncheck -ci, see oncheck -ci and -cI: Check index node links. For more information index pages, see Structure of B-Tree Index Pages.


Copyright© 2019 HCL Technologies Limited