SAPDBA for Informix (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

SAPDBA for Informix

Purpose

SAPDBA for Informix is an integrated database administration tool for Informix databases running with R/3 Systems, particularly large ones. You can use it without detailed knowledge of the database and its tools. It filters information about the database, showing you only what you need, and uses complex database statements to let you confidently manipulate the data while ensuring security and integrity.

Implementation Considerations

SAP recommends you to use SAPDBA rather than the Informix tools, because it is designed to run with R/3 databases. You should implement SAPDBA if you want to perform a wide range of database administration tasks, which are more difficult or unavailable with other tools. The following tasks can best be completed with SAPDBA:

Changing server mode

Adding or extending dbspaces, and dropping dbspaces or dropping chunks

Reorganization of tables, indexes, and dbspaces

Checking physical data consistency

Changing logging mode

Checking system information

For more information about setting up SAPDBA, see SAPDBA Setup.

Integration

The following SAPDBA functions are also available in the Computing Center Management System (CCMS) of the R/3 System:

Checking and updating cost-based optimizer statistics

Checking the DB system (that is, checking configuration and performance)

Monitoring of space usage in tables, indexes, and dbspaces

There are some tasks that can only be performed in CCMS (for example, scheduling backups).

Note

When the R/3 System is running, you can use CCMS to access some of the same information (but not all) found in SAPDBA. Whether to use SAPDBA or CCMS depends on the task you want to perform, and the setup of your system.

Features

Menu driven interface for ease of use

Runs with both Informix 6.0 and 7.x

Analysis facilities to examine the state of the database

Action facilities to carry out alterations to the database

Expert mode to enable privileged actions for authorized users

Menu interface in English or German

Context-sensitive supporting information

Available with operating systems UNIX and NT

See also:

SAPDBA and Informix Database Administration (in SAPNet)

Getting Started with SAPDBA