CAIENF Batch Database Query and Administration

This appendix describes commonly used batch database query and administration requests. These requests display information about CAIENF events and allow administration of database event tables. Administrators may design their own database queries.

Important! Updating or deleting tables must only be performed under the advice of CA CAIENF support personnel. CASQL004 and CADB001 must only be used under advice of CA CAIENF support personnel or as instructed by a maintenance PTF.

The following is a list of common requests:

• CASQL001 - Lists all CAIENF Event database tables.
• CASQL002 - Lists Event table event instances. A date range may be specified
• CASQL003 - Lists Event table count of event instances. A date range may be specified.
• CASQL004 - Deletes (DROP) an CAIENF database event table.

  Important! Use this job under advice of CA CAIENF CA Support only.

• CADB001 - Flushes database cache and closes all CAIENF tables. This job may be used with job CASQL004.

  Important! Use this job under advice of CA CAIENF CA Support only.