CHK EXPAND

PCP can expand compressed segments in order to verify the count of secondary index pointer records against the count of compressed secondary index target segments.

Additionally, when EXPAND(Y) is used in conjunction with PINDEX(Y) or SINDEX(Y) of the CHK parameter, PCP checks that the field contents of the primary or secondary index key fields match the contents of the main database key or data fields, even when those main database fields are compressed.

Note

You cannot invoke EXPAND(YES) by using the CHK(ALL) keywords. Instead, you must specify CHK(ALL,EXPAND(YES)).

Uses

You can set the CHK EXPAND option at the following levels:

  • GLBL control statement
  • CHECK control statement
  • CHECKALL control statement

PCPSYSIN keyword

CHK(EXPAND(value))

Values

Specify one of the following values:

  • YES or Y

    Expand compressed segments.

  • NO or N

    Do not expand compressed segments.

Default

N

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*