The History Database table CADTCM_HISTORY_SPL provides a persistent record of DBUTLTY SPILL executions. Detailed information is provided about each of the spills of the Log Area (LXX) to the Recovery File (RXX). This information can be used to determine the contents of each recovery file.
This information can be helpful when you find that you have a damaged database and need to recover the database from a previous backup. Once the backup is reloaded to the database, the database is at the point in time of the backup.
The spill history records help you to determine what RXX files are necessary to run a DBUTLTY forward recovery to bring the restored database forward in time.
Business Value
Typically when database damage occurs, and the user must restore a backup and do forward recovery, time-to-recover is of great importance. Unfortunately, the need to recover quickly can add additional pressure to the job of creating the recovery JCL.
If only one of the RXX files is missed or if the RXX files are specified in the wrong order, the forward recovery can fail and cause the user to restore the backup and run the recovery a second time.
By having the CADTCM_HISTORY_SPL table available, you can quickly determine all of the RXX files that have been created since the backup in question was created. Verify that these RXX files are provided in the correct sequence to the forward recovery process. This information not only speeds the job of creating the recovery JCL, but also improves the accuracy of the JCL creation.
Additional Considerations
The History Database automatically contains the additional CADTCM_HISTORY_SPL table in any system that has been installed or upgraded to the r12 level. This new table shares the same data area (A01) as the other History Database table CADTCM_HISTORY_ADS. Verify that the Index and data areas have been allocated, initialized and loaded null before starting the History Database.
The MUF startup option HISTORY must be added to the MUF startup to enable the statistical collection.
HISTORY dbid
Provides the database ID for the History Database. The standard implementation uses DBID 1007 for the History Database.
The spill statistics are created each time a DBUTLTY SPILL process is executed in a MUF environment with the LOGRCV=NO option specified.
For more information about using the History Database, see the CA Datacom/DB Database and System Administration Guide.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|