Requesting analysis during reorganization
Automatic pointer validation provides assurance of the area’s pointer integrity, while providing statistics that show how the reorganization process affected space usage.
Note
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).
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 following example 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.
Control statements for requesting analysis during reorganization
REORGANIZE DBD=<dbdname>,
RAP_VALIDATION=XREF,
REPORT
REPORT_DEFAULT=NO,
FREESPACE_ANALYSIS=YESFor more information about the reorganization process, see Reorganizing a DEDB online.
Comments
Log in or register to comment.