19.1.4 Notes on recovery of various types of RDAREAs

Organization of this subsection
(1) Recovering the master directory RDAREA
(2) Recovering data dictionary LOB RDAREAs
(3) Recovering user LOB RDAREAs
(4) Recovering list RDAREAs

(1) Recovering the master directory RDAREA

If the RDAREAs to be recovered include the master directory RDAREA, it is necessary to start HiRDB with the pdstart -r command and recover the master directory RDAREA with the pdrstr command.

In a recovery to the most recent synchronization point or with range specification, first recover the master directory RDAREA by itself, then recover the other RDAREAs.

(2) Recovering data dictionary LOB RDAREAs

The two data dictionary LOB RDAREAs are classified as follows:

The recovery timing differs for the two data dictionary LOB RDAREAs.

(a) Recovering the data dictionary LOB RDAREA for storing sources

The data dictionary LOB RDAREA for storing sources can be recovered to the backup acquisition point or to any synchronization point since the backup acquisition point. The backup and system log (unload log) are used as the input to the database recovery utility.

(b) Recovering the data dictionary LOB RDAREA for storing objects

The data dictionary LOB RDAREA for storing objects can be recovered only to the backup acquisition point because a database update log required for rollforward is not collected. Only the backup is used as the input to the database recovery utility.

In the following cases, follow the given procedure to recover the data dictionary LOB RDAREA for storing objects.

Procedure
To recover the data dictionary LOB RDAREA for storing objects:
  1. Use the pdmod command to reinitialize the data dictionary LOB RDAREA for storing objects:
    pdmod -a /pdmod/mod01
  2. Use ALTER ROUTINE to re-create the SQL objects of all stored routines and triggers.
    ALTER ROUTINE ALL

(3) Recovering user LOB RDAREAs

When user LOB RDAREAs are recovered, the user RDAREAs for storing the corresponding LOB column structure base tables should also be recovered at the same time.

(4) Recovering list RDAREAs

List RDAREAs do not become the targets of the pdrstr command. Because a list can be re-created if its base table is available, these RDAREAs are not subject to recovery.

If a list RDAREA is placed in error shutdown status, use the following procedure to release the shutdown status:

Procedure
To release the shutdown status for a list RDAREA:
  1. Use the pdclose command to close the RDAREA that has been placed in error shutdown status.
  2. Use the pdmod command to re-initialize the list RDAREA.
  3. Use the pdrels -o command to release the list RDAREA from error shutdown status and open it.
    Note
    If a list RDAREA is re-initialized, all lists in that RDAREA become unusable. In such a case, you must re-create the lists with the ASSIGN LIST statement.