DB System Checks in CCMS (Informix) 

Purpose

You can use the Computing Center Management System (CCMS) to run a series of performance and configuration checks on your Informix database system, including the following:

·        Parameters in the ONCONFIG file

·        Chunk and disk layout

·        Lock mode of tables

·        Number of extents for a table

·        Access rights for programs

The database system checks (shortened to "DB system checks") make no amendments to your database. The checks are easy to perform, are quickly finished, and have a minor effect on database performance. If problems arise, there is a detailed event log to help you find a solution.

You can also run the checks in SAPDBA. Refer to DB System Checks with SAPDBA.

Process Flow

SAP recommends you run the checks as follows:

Checks that are very important to database operation are run automatically without you having to do anything, and these checks raise alerts if required in the CCMS alert monitor. Some checks are run hourly, some daily. You can deactivate these checks if you want.

For more information, see Configuring DB System Checks in CCMS: Informix and Monitoring the Database with the Alert Monitor: Informix.

...

       1.      If required, you configure the checks to better suit your system. Refer to Configuring DB System Checks in CCMS (Informix).

       2.      You schedule the checks to run regularly. Refer to Checking the DB System in the DBA Planning Calendar (Informix).

       3.      If you have a problem with your database or you have changed the configuration, you run the checks to help find what is wrong or to make sure the new configuration is acceptable. Refer to Running DB System Checks in CCMS (Informix).

       4.      You view the results. Refer to Viewing DB System Checks in CCMS (Informix).

Result

Since many database problems can be traced to incorrect settings, the DB system checks enable you to easily identify common problems. The result is improved performance of your Informix database and high availability for your SAP System.