The RECOVERY_UNITS catalog table is a base table created by SESAM/SQL in the database's catalog space. RECOVERY_UNITS is used to administer SESAM backup copies of user spaces.
The contents of RECOVERY_UNITS
Each record in RECOVERY_UNITS contains information on a SESAM backup copy of a user space; the information includes the name of the user space, the time stamp assigned to the SESAM backup copy, and details of the DA-LOG file associated with the SESAM backup copy.
SESAM/SQL adds an appropriate record to the RECOVERY_UNITS table whenever the database administrator creates a SESAM backup copy of a user space with the utility statement COPY. The database administrator is responsible for maintaining the RECOVERY_UNITS table (see the section “Maintenance of the metadata of SESAM backup copies”).
The database administrator can view the contents of the RECOVERY_UNITS catalog table with the aid of the utility monitor (see the “Utility Monitor” manual).
The utility statement der MODIFY enables the database administrator to maintain the catalog table RECOVERY_UNITS (see the “SQL Reference Manual Part 2: Utilities”).