CAIENF Best Practices › Installation Considerations › CAIENF Database Queries

CAIENF Database Queries

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

• An CAIENF listener seems to have a missing event problem. A good first diagnosis step is to determine if the event was recorded in the CAIENF database.
• You wish to audit what happened when a particular job ran.
• You have some site-specific reason for inspecting recorded event data.

Because CAIENF r12 and above uses a CA Datacom/AD database, standard Datacom SQL jobs can be used to look at event data in the database. CAW0JCL data set members that start with CASQL, provide samples that you can use. The following is a description of 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 archive becomes necessary.