Checking the DB System in the DBA Planning Calendar (Informix) 

Use

You can use the DBA Planning Calendar in the Computing Center Management System (CCMS) to schedule database system checks against your Informix database. These check the configuration and performance of the database.

For more information about configuration and performance checks, see DB System Checks in CCMS (Informix).

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 about scheduling an action (for example, check DB system) in the DBA Planning Calendar, see Scheduling Actions in the DBA Planning Calendar.

Checks that you schedule from the DBA Planning Calendar are executed as follows:

·        Using the settings current at execution time

For more information about how to modify the settings for database system checks before running them in the DBA Planning Calendar, see Configuring DB System Checks in CCMS (Informix).

·        All checks are executed

That is, you cannot specify that only certain checks are executed for a given run.

Procedure

...

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

       2.      Choose the day when you want the check to be started.

       3.      Choose Create action.

       4.      Select Database Configuration Check.

       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 is now scheduled. It will be executed at the scheduled date and time, using the settings current at execution time. For more information about looking at the results, see Checking the Results of Actions in the DBA Planning Calendar.

For more specific information about how to see the results of the checks, see Viewing DB System Checks in CCMS: Informix.