StateChecker

Description

The StateChecker checks if any table or tablespace or index in the supplied object container is in a restricted or pending state. This check is required if you intend to execute any action on these objects that may fail if the objects are in an invalid state.

For example if you want to copy the tables using UNLOAD/LOAD it doesn’t make sense to copy a tablespace that is in recovery pending state.

Names

Short

statechk
Full

StateChecker

Input parameters

Parameter Description

inputFile

The object container file containing structure information to be checked.

Output parameters

Parameter Description

return code

Return code of the program, RC=8 if one or more objects are in invalid state.

Output information

If the StateChecker detects any objects that are in an invalid state, the number of affected tables and tablespaces is logged.