Start of Content Area

Function documentation Reorganization with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Informix to view the storage parameters on database objects (that is, tables and indexes) and, if necessary, reorganize the objects. Storage parameters include extent sizes, locking modes, dbspace for a table, and so on. If you use SAPDBA to view storage parameters and reorganize, you do not need to know the Informix commands.

Having completed an analysis of a table or index, you might then decide on a reorganization to resolve the problem.

Integration

Reorganization is fully integrated in SAPDBA. You can use this functionality for databases running on UNIX and NT operating system platforms.

Prerequisites

You need to know how to use SAPDBA and to have set it up correctly. Refer to Getting Started with SAPDBA.

Features

Activities

  1. You use the SAPDBA reports to analyze the storage of database objects. Refer to Storage Analysis of Tables and Indexes with SAPDBA.

    2. Note

    If a reorganization is required, alerts are also raised in the Release 4 alert monitor in the Computing Center Management System of the R/3 System. For more information, see Monitoring the Database with the Release 4 Alert Monitor (Informix).

  2. If you want to monitor storage of database objects online in the R/3 System, you can use the DBA operations monitor in the Computing Center Management System (CCMS). See Using the DBA Operations Monitor.
  3. You use SAPDBA to perform the reorganization on the database object with the problem. Refer to Reorganization of Tables, Indexes, and Dbspaces with SAPDBA.

 

See also:

Informix documentation

Management of Informix Database Growth