Reporting audit problems as exceptions

You can request the AUDIT function through the Advisor scheduling service in the console or through the batch CPCTSCHD program.

The AUDIT function reports a potential problem as the highest-level Not Analyzed (orange) exception for the database in the Exception List.

AUDIT also produces a report in the CPCLOG data set of the Advisor server. The report indicates conditions that you might need to review:

  • Analysis flag off
  • Analysis overdue
  • Capture statistics flag off
  • Data collection overdue
  • Database collection not scheduled

To request the AUDIT function through the console

  1. In the navigation window, right-click the IMSPLEX object and choose Configuration > Schedules.
  2. In the Schedules window, double-click the AUDIT row in the table.
  3. In the Edit Schedules dialog box, specify the schedule parameters.
  4. Click Save.

To request the AUDIT function with program CPCTSCHD

Create a job to execute program CPCTSCHD, as explained in Using-program-CPCTSCHD-to-initiate-Advisor-scheduled-tasks.

Related topic

Auditing-databases-to-ensure-analysis


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*