Reorganization of Tables, Indexes, and Dbspaces wi (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Reorganization of Tables, Indexes, and Dbspaces with SAPDBA

Purpose

You can use SAPDBA for Informix to reorganize tables, indexes, and dbspaces.

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You are logged on in expert mode, that is, as user informix , and you have started SAPDBA. Refer to Starting SAPDBA.

You have completed a storage analysis of tables and indexes with SAPDBA. This helps you identify the table, index, or dbspace that you want to reorganize.

Process Flow

You choose the type of reorganization required:

Reorganizing a Single Index with SAPDBA

Reorganizing All Indexes of One Table with SADPBA

Reorganizing a Single Table with SAPDBA

Reorganizing a Group of Tables with SAPDBA

Reorganizing a Dbspace and Its Tables with SAPDBA

Result

After a reorganization, your database is less likely to run into space problems. However, you need to keep on monitoring the space situation. Refer to Storage Analysis of Tables and Indexes with SAPDBA.

See also:

Informix documentation