Event Notification Facility › Restore Events

Restore Events

The CAS9DUTL batch database utility supports the RESTORE command to restore event data from one or more archive data sets into a database table that is associated with the event.

You can restore archived events into either a temporary or an active event table. The description of the table in the database that receives the archived event data must match the description of the table found in the archive data set selected by the restore utility. By default, event data is restored into a temporary table.

When restoring event data into a temporary table:

• If the temporary table does not exist, it is created for you using information that is found in the first archive data set that is opened that satisfies the restore request. The temporary table name is created by prefixing the event name with CAS9TMP_.
• If the temporary table already exists, it must match the description of the table in the archive data set, or it must be dropped before running the restore job.

The temporary tables are not selected during the archive/purge process. A temporary table remains defined to the database until you drop the table. You can drop a temporary table using JCL found in the CAW0JCL data set member CASQL004 with a SYSIN statement similar to the following statement:

DROP TABLE CAS9ENFS.CAS9TMP_XXXXXXXX;

CAS9TMP_

Indicates that the table to be dropped is a temporary table.

XXXXXXXX

The event table name.

To restore event data to the active event table, the JCL to run the restore utility must contain the TBUPDATE parameter on the EXEC card:

//STEP1 EXEC PGM=CAS9DUTL,PARM='TBUPDATE'

When restoring event data into an active event table, the table must already exist in the database. Active event tables are created at the CAIENF initialization based on the EVENT commands specified. The restored event data remains until the next archive/purge process occurs. The newly restored event data is then rearchived and purged or only purged.

Use the batch job CASQL005 located in the CAW0JCL data set to display information about the archives. Only archives found in the table can be used to restore an event.

The archive table includes the following information:

Archive Date

The day the archive was performed.

Archive Time

Time of day the archive was performed.

Event Name

The name of the archived event.

First Date

The date of the first record in the archive for the event.

Last Date

The date of the last record in the archive for the event.

Volser

The volser of the tape or DASD for the archive.

Data Set Name

The archive data set name.

Use the output information that the CASQL005 job generates to create the appropriate CAS9DUTL restore request.

The EVENT parameter identifies the event and the FROM and TO parameters are used to specify a date range of events to be restored.

Example:

RESTORE EVENT(event_name) FROM(yyyyddd) TO(yyyyddd)

The batch JCL to execute the RESTORE operation is located in the CAW0JCL data set member CADB002.