Nonstop Database, HiRDB Version 9 System Operation Guide
(1) Use the pdhold command to shut down the data dictionary RDAREA and data dictionary LOB RDAREA
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
|
(2) Back up the data dictionary RDAREA and the data dictionary LOB RDAREA
To be prepared for the possibility that an error might occur during reorganization, back up the data dictionary RDAREA and the data dictionary LOB RDAREA. If the size of either of these RDAREAs becomes insufficient during reorganization of the dictionary table needed for RDAREA extension, you must be able to recover the RDAREA from a backup since the RDAREA cannot be extended. If a unit goes down during reorganization of the dictionary table, you must also be able to recover the RDAREA from a backup since the front-end server cannot reference the dictionary table during HiRDB startup, and goes into SUSPEND status. For details about how to determine whether the RDAREA needs to be recovered from a backup, see the conditions described below in (7) Note.
(3) Create the control statements file for the pdrorg command
The following are the contents of the control statements file (/pdrorg/rorg01):
unload /pdrorg/unfile1 1
lobunld /pdrorg/unfile2 2
|
- Explanation
- Specifies the name of the unload data file for the data dictionary RDAREA.
- Specifies the name of the unload data file for the data dictionary LOB RDAREA.
(4) Use the pdrorg command to reorganize the data dictionary table
pdrorg -k rorg -c dic /pdrorg/rorg01
|
- Explanation
- -k: Specifies rorg in order to execute reorganization.
- -c: Specifies that a data dictionary table is to be reorganized.
- /pdrorg/rorg01: Specifies the name of the control statements file for the pdrorg command created in step (3).
(5) Back up the data dictionary RDAREA and the data dictionary LOB RDAREA
(6) Use the pdrels command to release the data dictionary RDAREA and data dictionary LOB RDAREA from shutdown status
pdrels -r DATADIC,DATALOB
|
We recommend that after the command has executed you check whether the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 9 Command Reference.
Exercise caution if the following error occurs during the reorganization of a dictionary table:
- Although unloading was completed, during reloading a capacity shortage occurred in the data dictionary RDAREA.
In such a case, take appropriate action according to whichever of the conditions listed below is applicable.
- Condition 1:
- When the database reorganization utility is executed in the update log acquisition mode or the pre-update log acquisition mode, and reloading of the SQL_PHYSICAL_FILES table and the SQL_RDAREAS table has been completed:
- Use the database structure modification utility to expand or add the dictionary RDAREA and the data dictionary LOB RDAREA.
- Without changing the option or control statement specification, re-execute the database reorganization utility.
- Condition 2:
- When the database reorganization utility is executed in the update log acquisition mode or the pre-update log acquisition mode, and reloading of the SQL_PHYSICAL_FILES table and the SQL_RDAREAS table has not been completed, or when the database reorganization utility is executed in the no-log mode:
- Using the backup made before reorganizing, execute the database recovery utility to recover the data dictionary RDAREA and the data dictionary LOB RDAREA.
- Use the database reorganization utility to expand or add the data dictionary RDAREA and the data dictionary LOB RDAREA.
- Reorganize the dictionary table again.
Using the unload data file created before the error occurred (before the RDAREAs were expanded or added), perform everything but reloading.
- The unit went down during reloading and HiRDB was restarted, but the problem was recognized as an error in the dictionary RDAREA and the front-end server was placed in SUSPEND status (in the case of a HiRDB parallel server configuration).
In such a case, take the following actions:
- Using the backups acquired before the reorganization and the database recovery utility, restore the data dictionary RDAREA and the data dictionary LOB RDAREA.
- Use the pdstart -a command to start HiRDB.
For details, see 1.3.3 Startup procedure used when the front-end server is in SUSPEND status due to an error in a data dictionary RDAREA (pdstart -a).
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.