This example reorganizes data dictionary tables that are stored in the data dictionary RDAREA (DATADIC) and in a data dictionary LOB RDAREA (DATALOB). Reorganize the dictionary table in the pre-update log acquisition mode (default).
You will be backing up the RDAREAs while they are in shutdown status. After you have backed them up, keep the RDAREAs in shutdown status so that other users do not update their contents.
pdhold -r DATADIC,DATALOB |
To be prepared for the possibility that the RDAREAs will prove to be too small during reorganization, back up the data dictionary RDAREA and the data dictionary LOB RDAREA. If the size of the data dictionary RDAREA or the data dictionary LOB RDAREA becomes insufficient during reorganization, you will have to be able to recover the RDAREAs from a backup. For details about backing up RDAREAs, see 6.4.6 Example 6 (Backing up RDAREAs).
The following are the contents of the control statements file (/pdrorg/rorg01):
unload /pdrorg/unfile1 1 |
pdrorg -k rorg -c dic /pdrorg/rorg01 |
Back up the data dictionary RDAREA and the data dictionary LOB RDAREA (DATADIC and DATALOB). For details about backing up RDAREAs, see 6.4.6 Example 6 (Backing up RDAREAs).
pdrels -r DATADIC,DATALOB |
It is recommended that after the command has executed you check whether or not the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 8 Command Reference.
Exercise caution if the following error occurs during the reorganization of a dictionary table:
In such a case, use the procedure explained below to reorganize the dictionary table.