Database Utilities › Database Restore (SARRSP)

Database Restore (SARRSP)

Use the SARRSP utility program to restore all panels, messages, or SYSOUT groups that reside in disk status to the database. These entities can be from either SARDBASE UNLOAD tapes or CA View backup tapes. This utility must be executed after the normal restore process provided with the SARDBASE utility (RESTORE control statement).

In certain situations, the restore function provided with the SARDBASE utility cannot fully restore the contents of the database.

It works this way:

• The SARDBASE restoration process attempts to copy panels, messages, and SYSOUT groups from the old database, if specified, to repopulate the database.
• When the old database is severely damaged or does not exist, panels, messages, and SYSOUT groups that are unsuccessfully copied occupy an empty file.

  In this case, the SARTDR utility (tape dump restore utility) is normally used to reload entire tapes or generations back to the database.

• With the ability of the expanded retention option to maintain SYSOUT on disk for long periods of time, the restoration process requires a vast amount of disk space. There must be enough space to hold SYSOUT that didn't previously reside on disk.

The SARRSP utility attempts to restore any panel data, message data, or non-resident SYSOUT group in two ways:

• From a CA View unload tape (if the SARLOAD DD statement is specified)
• Dynamically, from the CA View backup tape

  The backup tapes are dynamically allocated, if needed, by tape sequence number. In cases where the backup tape is damaged or unusable, the respective SYSOUT groups are removed from disk status.

Note: If all panel and message data is not completely restored, after the restore process you must reload the online library (panels and messages) to the database with the SARDBASE utility (OLOAD control statement).