Requesting analysis during reorganization

This automatic process applies the default value QUICK for the POINTER_VALIDATION keyword. The analysis function performs a checksum validation of pointers for each segment type within each UOW of the database that is specified on the REORGANIZE command.

Automatic pointer validation provides assurance of the area’s pointer integrity, while providing statistics that show how the reorganization process affected space usage.

If an SDEP segment is defined for the database and the number of UOWs for IOVF control intervals is being extended (using the EXTEND_IOVF_#UOWS keyword), SDEP pointers are also validated (by default) by using the same technique as specified for direct pointers. You can manually specify another valid value for the SDEP_VALIDATION keyword to control how SDEP pointers are to be validated.

You can also specify additional functions that are associated with the analysis function:

• Use the RAP_VALIDATION keyword to control how RAPs are processed.
• Use the LARGEST_DATABASE_RECORDS keyword to specify the number of largest database records to be tracked by the analysis process.
• Use the REPORT and THRESHOLD subcommands to control the generation of analysis reports and exception testing.

Because no values are specified for the POINTER_VALIDATION and SDEP_VALIDATION keywords, the example in the following figure requests that pointer validation be performed during reorganization of the area by using the QUICK (checksum) technique and that no validation of SDEP pointers is performed. Full validation for RAP pointers is requested explicitly. The example produces only the Free Space Analysis Report and does not check threshold conditions.

For more information about the reorganize process, see Reorganization-of-a-DEDB.