Event Notification Facility › CAIENF Customization Considerations › CAIENF Database Queries

CAIENF Database Queries

When CAIENF is set up to record events to the CAIENF database, events can be queried for the following reasons:

• A CAIENF listener seems to have a missing event problem. We recommend that you start by determining whether the event was recorded in the CAIENF database.
• You want to audit what happened when a particular job ran.
• You have a site-specific reason for inspecting recorded event data.

Because CAIENF Version 12.0 and above uses a CA Datacom/AD database, you can use standard Datacom SQL jobs to review event data in the database. CAW0JCL data set members that start with CASQL, provide samples that you can use. The following list describes the sample members:

CASQL001

Displays the names of the available event tables on the database in case you are not familiar with the event names. You need the event table names to use the other sample CASQLnnn members.

CASQL002

Performs a standard SQL query for reporting on event data.

CASQL003

Reports on the number of recorded events of the specified event name.

CASQL004

(Not for query purposes.) Used for DCM replacement situations only.

CASQL005

Provides archive data so the restore job can be set up properly in rare cases where a restore from the archive becomes necessary.