DBUTLTY OLREORG with REFGROUP=0 for Disk Backup and Restore tables
searchcancel
DBUTLTY OLREORG with REFGROUP=0 for Disk Backup and Restore tables
book
Article ID: 200729
calendar_today
Updated On: 12-16-2024
Products
DatacomDatacom/DBDatacom/ADDISK BACKUP AND RESTOREDisk Backup and Restore - MVS
Issue/Introduction
What are the required steps to set up Datacom OLREORG (Online Reorg) with REFGROUP=0 in order to perform a reorganization of the Disk Backup and Restore tables?
Check if the DSOP value is already set to 4 (RANDOM FOR OLREORG): run a DBUTLTY CXX report for the Disk database and search for the "DSOP MODE" string for the DMS area. If the value is not "RANDOM FOR OLREORG", then you can dynamically change it running these additional steps:
The very first OLREORG on a table could take several hours to complete (it could run longer than 24 hours, depending on the number of rows on the table and how badly the data are currently organized); you can cancel the OLREORG job (or REQABORT the related Datacom request) and then resubmit the job later.
The process will cause a number of SPILL requests during the execution, and they must be run immediately to avoid MUF to stop performing the updates. This is because LXX has to record each and every row that is moved by OLREORG.