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 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 will receive 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 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.

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:

DROP TABLE CAS9ENFS.CAS9TMP_XXXXXXXX;

CAS9TMP_ indicates that the table to be dropped is a temporary table and XXXXXXXX should be replaced with 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 as follows

//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 ENF initialization based upon the EVENT commands specified. The restored event data remains until the next archive/purge process occurs. The newly restored event data is then re-archived and/or 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 generated by the CASQL005 job 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.