Previous Topic: Sample JCL: CAUNZIP Utility to Extract the Zip File in NTS format


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 can 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.

A list of common requests:

CASQL001

Lists all CAIENF Event database tables.

CASQL002

Lists Event table event instances. A date range can be specified.

CASQL003

Lists the Event table count of event instances. A date range can be specified.

CASQL004

Deletes (DROP) a 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 can be used with job CASQL004.

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