DA_LOGS catalog table

The DA_LOGS table is a base table created by SESAM/SQL in the database's catalog space. DA_LOGS is used to administer the DA-LOG files.

The contents of DA_LOGS

Each record in DA_LOGS contains (among other things) the name of a DA-LOG file, the time stamp assigned to this DA-LOG file, and information on the user spaces for which changes are logged in this DA-LOG file. In combination with the RECOVERY_UNITS catalog table, the DA_LOGS catalog table supplies all the information that SESAM/SQL requires in order to repair user spaces.
Whenever SESAM/SQL switches to a new DA-LOG file, it adds an appropriate record to the DA_LOGS catalog table. The database administrator is responsible for maintaining the DA_LOGS table (see the section “Maintenance of the metadata of SESAM backup copies”).

The database administrator can view the contents of the DA_LOGS catalog table with the aid of the utility monitor (see the “Utility Monitor” manual).
The utility statement MODIFY enables the database administrator to maintain the catalog table DA_LOGS (see the “SQL Reference Manual Part 2: Utilities”).