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?
OLREORG with REFGROUP=0 requires the Data Space Option (DSOP) attribute set to 4 or 5. This requires PTF RO90201 (Disk Backup and Restore V12.5, titled "ARCHIVE U0100 ABEND DUE TO INCORRECT RCF KEYS" to change the DSOP value from 1 to 4 (RANDOM FOR OLREORG).
Because this utility makes use of empty blocks, it is necessary that there is at least 30% free space in the area being reorganized.
Here are the steps to follow to prepare the Disk DMS Area to use OLREORG with REFGROUP=0:
//SYSIN DD *
CXXMAINT DBID=nnn,AREA=DMS,OPTION=ALTER,DSOP=4
/*
//SYSIN DD *
DATASCAN DBID=nnn,AREA=DMS,OPTION=REBUILD_SPACE_INDEX
/*
//SYSIN DD *
ACCESS DBID=nnn,STATUS=OFF,USERS=WAIT
COMM DBID=nnn,OPTION=CLOSE
ACCESS DBID=nnn,STATUS=WRITE
COMM OPTION=CONSOLE,OPTION2='OPEN_BASE nnn'
/*
At this point, the Disk area is ready for the OLREORG with REFGROUP=0 process; run DBUTLTY on each table:
//SYSIN DD *
OLREORG DBID=nnn,TABLE=ttt,REFGROUP=0
/*
Important notes:
For more information about the OLREORG process, please review the documentation topic OLREORG (Reorganize a Database Online).
As always, please contact Broadcom support for Datacom if you have further questions.