Checking Statistics in the DBA Planning Calendar (Informix) 

Use

You can use the DBA Planning Calendar in the Computing Center Management System (CCMS) to schedule a check to see whether the statistics on the Informix database need updating. You can only schedule check statistics for all tables in the database.

The information generated by this function is evaluated for the “Optimizer Statistics” alert. Refer to Monitoring Optimizer Statistics (Informix). For more information, see SAP Note 64210.

You can also schedule an update statistics in the DBA Planning Calendar. Refer to Updating Statistics in the DBA Planning Calendar (Informix).

For more information about update statistics – which you can also perform with SAPDBA (that is, outside CCMS) – see Update Statistics with SAPDBA.

Prerequisites

·         You are ready to use CCMS. Refer to Getting Started in CCMS with Informix DBA.

·        You know how to use the DBA Planning Calendar. For more information, see:

For more information about scheduling an action (for example, check statistics) in the DBA Planning Calendar, see Scheduling Actions in the DBA Planning Calendar.

Procedure

...

       1.      Choose CCMS ® DB Administration ® DBA Planning Calendar.

       2.      Choose the day when you want the statistics to be checked.

       3.      Choose Create action.

       4.      Select Check: upd. stat. needed (for all tabs).

       5.      Enter data as required in the fields Start Time, Period (weeks), and Calendar. For more information, see Scheduling Actions in the DBA Planning Calendar.

       6.      Choose Continue.

Result

The check statistics is now scheduled. It will be executed at the scheduled date and time. For more information about looking at the results of the check statistics, see Checking the Results of Actions in the DBA Planning Calendar.