CCMS: Informix 
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 SAP 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 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:
· CCMS uses the familiar SAP interface, can be used directly from your SAP session and is perfectly adequate for many routine functions.
· SAPDBA is tailored for use with the SAP system running on Informix databases and can also be used when the SAP system is down. With SAPDBA, you can perform a wide range of DBA functions (but not archive and backup).
· The Informix tools have the disadvantage that they are not designed specifically to run with the R/3 System, and furthermore some of these tools have a less advanced interface than SAPDBA or CCMS.
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 |
SAPinst |
|
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 |
|
|
Reviewing results of archive and backup |
|
|
Update Statistics |
|
|
Performance tuning and monitoring |
|
|
System checks (that is, configuration and performance) |
There is some overlap between these tools.
Constraints
You have to perform certain DBA functions outside the SAP system, that is, using tools supplied by Informix and SAP. For example, to perform a reorganization, you have to use SAPDBA.
See also: