SAP/Informix DBA in CCMS 

Purpose

This component enables you to manage your Informix database using the Computing Center Management System (CCMS). With CCMS, you get extensive support in database administration (DBA) for the Informix database and can perform many DBA functions from within the R/3 System.

Implementation Considerations

SAP recommends you to use CCMS for Informix DBA where possible. CCMS is supported for Informix databases on both UNIX and Windows NT platforms.

For each area of administration, the table below in "Integration" shows the available tools. In general, you should use CCMS or SAPDBA as first choice, followed by the other Informix tools. The reasons for this are as follows:

There are some overlaps in functionality between CCMS and SAPDBA. In general, however, they complement one another, as their strengths lie in different areas. For example, CCMS is more suited for shared memory parameters, whereas SAPDBA is better for monitoring and tuning in the area of space management.

These are only guidelines as to the best tool for the task. The exact nature of the task determines which tool you should use.

Integration

There are many different tasks involved in Informix database administration, only some of which you can carry out using CCMS, as shown in the following table:

Area of administration

Can be performed using

Installation

R3SETUP

Archive and backup

CCMS, ontape, ON-Archive, ON-Bar

Reorganization

SAPDBA

Update statistics

CCMS, SAPDBA, Informix tools

Performance tuning

CCMS, SAPDBA, Informix tools

Monitoring

CCMS, SAPDBA, Informix tools

Space management

SAPDBA, Informix tools

System checks

SAPDBA, Informix tools, CCMS

Other

SAPDBA, Informix tools

Features

The main features for Informix DBA in CCMS are as follows:

Area of administration

Can be performed in CCMS using

Scheduling archive, backup, update statistics, DB system checks, physical consistency checks, and other tasks

DBA Planning Calendar

Reviewing results of archive and backup

Archive and Backup Monitor in CCMS

Update Statistics

Update Statistics

Performance tuning and monitoring

Database Monitor and Database Alert Monitor

System checks (that is, configuration and performance)

DB System Check

There is some overlap between these tools.

Constraints

You have to perform certain DBA functions outside the R/3 System, that is, using tools supplied by Informix and SAP. For example, to perform a reorganization, you have to use SAPDBA.

 

See also:

BC R/3 Database Guide: Informix