13.4.2 Options

Organization of this subsection
(1) -k {check|set|release}
(2) -t [authorization-identifier.]table-identifier
(3) -c [authorization-identifier.]constraint-name
(4) -u authorization-identifier
(5) -o process-results-file-name
(6) -q {generation-number|all}
(7) -w maximum-number-of-violation-key-values-that-can-be-output
(8) -x integrity-checking-monitoring-interval

(1) -k {check|set|release}

Specifies the function that pdconstck is to perform:

check
Executes the integrity check facility.
set
Executes the facility for changing check pending status forcibly (forced setting of check pending status).
release
Executes the facility for changing check pending status forcibly (forced release of check pending status).

(2) -t [authorization-identifier.]table-identifier

~<identifier>

Specifies the table identifier of the referencing table or check constraint table that is to be processed.

If the authorization identifier is omitted, the authorization identifier of the user who connected to HiRDB is assumed. For details about the authorization identifier of the user who connected to HiRDB, see 13.1(2) Authorization identifier during execution of pdconstck.

Criteria
Specify this option when you execute the integrity check facility or the facility for changing check pending status forcibly by table.
Rules
  1. You can specify only a table for which referential constraints (foreign keys) or check constraints have been defined.
  2. A view table cannot be specified.
  3. If an authorization identifier or table identifier is enclosed in double quotation marks ("), the system treats it as being case sensitive; otherwise, the system treats it as all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier in single quotation marks (').

(3) -c [authorization-identifier.]constraint-name

~<identifier>

If the authorization identifier is omitted, the authorization identifier of the user who connected to HiRDB is assumed. For details about the authorization identifier of the user who connected to HiRDB, see 13.1(2) Authorization identifier during execution of pdconstck.

Criteria
Specify this option when you execute the integrity check facility or the facility for changing the check pending status forcibly by constraint.
Rules
If an authorization identifier or constraint name is enclosed in double quotation marks ("), the system treats it as being case sensitive; otherwise, the system treats it as all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier or name in single quotation marks (').

(4) -u authorization-identifier

~<identifier>

Specifies the authorization identifier used to connect to HiRDB.

When this option is specified, the system displays a message requesting entry of a password. If no password is required, enter the null in response to the message. For details about the default authorization identifier and password that are assumed when this option is omitted, see 13.1(2) Authorization identifier during execution of pdconstck.

Criteria
Specify this option to connect to HiRDB using a different authorization identifier from the one specified in the PDUSER environment variable.
Rules
If an authorization identifier is enclosed in double quotation marks ("), the system treats it as being case sensitive; otherwise, the system treats it as all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier in single quotation marks (').
Notes
You must specify PDUSER if you are executing the utility in the background with & attached by the shell, or in a remote shell environment in which a password cannot be entered. You must specify PDUSER when you are executing this utility in an environment in which a password cannot be entered.

(5) -o process-results-file-name

~<path name>

Specifies the name of the process results file to which the processing results are to be output.

Criteria
Specify this option to create the process results file in the directory of your choice.
Rules
  1. The specified path must be to the host where pdconstck is executed.
  2. Write privileges must have already been granted by the executor of pdconstck for the file specified by the path name (high-order directory).
Default value
When this option is omitted, the process results file is created as follows:
  • Directory in which the process results file is created
    /tmp directory
  • Name of the process results file
    CONSTCK-REPORT-table-name-xxxxxxxxx
    table-name
    Table identifier specified in the -t option or the table identifier for which the constraint specified in the -c option was defined (1 to 30 characters)
    xxxxxxxxx
    Unique characters acquired by an OS function (tmpnam) (9 characters)

(6) -q {generation-number|all}

~<unsigned integer> ((1-10))

When the inner replica facility is used, specifies the generation that is to be processed:

0: The original RDAREAs are to be processed.
1 to 10: The indicated generation of the replica RDAREAs is to be processed.
all: The original RDAREA and all generations of replica RDAREAs are to be processed.
Criteria
Specify this option when you use the inner replica facility and wish to execute the integrity check facility or the facility for changing check pending status forcibly by generation.
Rules
  1. You can specify this option only when you use the inner replica facility.
  2. When the -c option is specified, a generation number cannot be specified (only all can be specified).
  3. You can specify only the generation number of replicas of table storage RDAREAs that store the table specified in the -t option, or of replicas of the table for which the constraint specified in the -c option has been defined.
  4. The following shows the default value that is assumed when the inner replica facility is used and this option is omitted:
    -t option-c optionDefault value
    SpecifiedOmittedCurrent RDAREA generation
    OmittedSpecifiedall

(7) -w maximum-number-of-violation-key-values-that-can-be-output

~<unsigned integer> ((1-30000)) <<60>>

The integrity check facility enables you to output to the process results file the key values that violate constraints. This option specifies the maximum number of such violation key values that can be output per constraint (by generation when the inner replica facility is used).

Criteria
Specify this option when you want to reduce file size by limiting output of key values resulting in a constraint violation.
Rules
  1. Duplicated key violation values are not output. However, in the case of a check constraint, if the data types of columns related to a check constraint include a BLOB or BINARY column, duplicates are not eliminated.
  2. Once the number of violation key values reaches the specified value (or the default value), no more violation key values are output to the process results file. When this happens, the utility cancels integrity checking on the corresponding constraint (corresponding generation) and performs integrity checking on the next constraint (generation).

(8) -x integrity-checking-monitoring-interval

~<unsigned integer> ((0-65535)) <<0>>

Specifies the interval in seconds at which integrity check preprocessing and integrity checking on a single constraint (single generation) are to be monitored. If the amount of time spent on integrity check preprocessing or integrity checking on a single constraint (single generation) exceeds the monitoring interval specified in this option, pdconstck outputs the applicable message shown below and then terminates with return code 8:

Criteria
You should specify this option in the event of a failure such as the one listed below, and it is advisable to monitor execution time in order to check whether or not pdconstck has stopped responding:
  • Communication failure (communication between pdconstck and HiRDB server or communication between HiRDB servers)
  • Non-responsive process due to a failure (such as a disk failure)
Rules
The pdconstck processing depends on the combination of the -x option and the pd_lck_wait_timeout operand in the system definition. The following table describes the possible combinations and the pdconstck processing.
pd_lck_wait_timeout operand value-x option valuepdconstck processing
00Waits until it receives a response from the HiRDB server.
OtherWhen the -x option value is exceeded, pdconstck terminates with return code 8.
Other0When the pd_lck_wait_timeout operand value is exceeded, pdconstck terminates with return code 8.
Less than the pd_lck_wait_timeout operand valueWhen the -x option value is exceeded, pdconstck terminates with return code 8.
Same as the pd_lck_wait_timeout operand valueWhen the pd_lck_wait_timeout operand value is exceeded, pdconstck terminates with return code 8.
Greater than the pd_lck_wait_timeout operand value