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.

The two data dictionary LOB RDAREAs are classified as follows:

• For storage of the sources for stored routines and triggers
• For storage of the objects of stored routines and triggers

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.

• You are recovering the data dictionary LOB RDAREA for storing sources to a synchronization point after the backup acquisition point, but the data dictionary LOB RDAREA for storing sources cannot be synchronized with the data dictionary LOB RDAREA for storing objects
• The backup was collected by the pdcopy command with the -J option specified, but the data dictionary LOB RDAREA for storing objects was intentionally not backed up

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
   

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.

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.