The CAT-REC file contains entries pertaining to the SESAM backup copies of the catalog space, and information on the CAT-LOG files. Refer to section “Files and tables used for media recovery” for a detailed description of the CAT-REC file.
Using the utility monitor, the database administrator can view information on the content of the CAT-REC file. He/she can also modify CAT-REC files online or offline and therefore delete records on SESAM backup copies that are no longer required from a CAT-REC file (see the “Utility Monitor” manual).
The utility statement MODIFY enables the database administrator to modify the current CAT-REC file online (see the “SQL Reference Manual Part 2: Utilities”).
The CAT-REC file should always be mirrored using dual recording by volume or dual copy. It is possible to back up the CAT-REC file when the database is no longer added to an SQL database catalog. Changes made after this backup would, however not be automatically logged, so that the CAT-REC file could only be recovered to the status of this SESAM backup copy when required.