Requesting analysis during reorganization

If your site has a license for Fast Path Analyzer/EP, it performs pointer validation automatically (by default) when you execute an offline reorganization by using the Fast Path Reorg/EP REORGANIZE command.

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.


You can override automatic quick pointer validation and request more detailed validation by specifying POINTER_VALIDATION=FULL on the REORGANIZE or GLOBAL command. Direct pointers are validated by using the cross-reference technique. You can also specify any other valid value for the POINTER_VALIDATION keyword (such as POINTER_VALIDATION=NONE to completely disable the analysis process).

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.

Related topic

Was this page helpful? Yes No Submitting... Thank you