Start of Content Area

Process documentation DB System Checks with SAPDBA  Locate the document in its SAP Library structure

Purpose

You can use SAPDBA to run a series of configuration and performance checks on your database settings. The settings you can check include:

The checks make no amendments to your database. You can also perform the checks in the Computing Center Management System (CCMS). Refer to DB System Checks in CCMS (Informix). The checks are easy to perform, are quickly finished, and have a minor effect on database performance while running.

Process Flow

SAP recommends you run the checks as follows:

  1. If required, you configure the checks to better suit your system. Refer to Configuring DB System Checks in CCMS (Informix).
  2. To prevent problems arising, you run the checks regularly. For more information on how to regularly schedule the checks using the DBA Planning Calendar in CCMS, see 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 Checking the DB System with SAPDBA.

Result

Since many database problems are due to incorrect settings, the DB system checks in SAPDBA help you to easily identify common problems. The result is improved performance of your database and high availability for your R/3 System.