ENF Batch Database Query and Administration

This appendix describes commonly used batch database query and administration requests. These requests display information about ENF 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 ENF support personnel. CASQL004 and CADB001 must only be used under advice of CA ENF support personnel or as instructed by a maintenance PTF.

The following is a list of common requests:

• CASQL001 - Lists all ENF 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 ENF database event table.

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

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

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