Datacom/DB - OLREORG checkpoint frequency and interruption procedures
Article ID: 143677
Updated On:
Products
Issue/Introduction
Determine the frequency of checkpoints taken during the execution of a DBUTLTY Online Reorg (OLREORG). Verify if the OLREORG process can be cancelled or stopped via a REQABORT command.
Cause
OLREORG is a row-level processor and does not utilize traditional database checkpoints.
Resolution
The DBUTLTY Online Reorg (OLREORG) function operates as a row processor where each individual row movement represents a stable point. Consequently, OLREORG does not require or execute traditional database checkpoints. This architectural design allows the Multi-User Facility (MUF) to interrupt or stop execution without risk to the environment.
To stop an active OLREORG, execute a COMM REQABORT command. Upon termination, rows already relocated remain in their new positions, while rows not yet reached by the scan are bypassed. If an OLREORG job is cancelled via system commands, identify the key for the last row processed (LASTKEY) from the report. To resume the process without re-scanning previously completed rows, specify this value in the FIRSTKEY parameter of the subsequent OLREORG statement.
OLREORG is designed to run concurrently with standard production workloads. During execution, applications maintain full access to the specified table. If OLREORG encounters a row held under primary or secondary exclusive control by another task, it skips the row to preserve performance.
Additional Information
References
Feedback
