Reorganizing a Group of Tables with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Reorganizing a Group of Tables with SAPDBA

Use

You can use SAPDBA for Informix to reorganize groups of tables. For more information, see Reorganization of a Group of Tables or Dbspace with SAPDBA.

Note

In normal operation, you do not need to regularly reorganize the tables in Informix databases. Therefore, make sure you have a good reason before you reorganize.

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 analyzed the storage parameters for the tables and dbspaces to make sure that the reorganization is necessary. Refer especially to the following:

Analyzing Tables by Fill Level, Size, and Extents

Analyzing Tables for Critical Next Extent Size with SAPDBA

You have completed the preparations for reorganizing a group of tables.

Procedure

Choose Reorganization ® Reorganize Group of Tables in SAPDBA for Informix.

Select the reorganization method you want:

Tables in Dbspace by 'alter fragment …'

Tables in Dbspace by 'insert into select from'

Tables Listed in File by 'alter fragment …'

Tables Listed in File by 'insert into select from …'

For more information about the reorganization methods, see Reorganization of a Group of Tables or Dbspace with SAPDBA.

SAPDBA prompts you as follows:

If you are reorganizing with the	Then SAPDBA prompts you for the
"Tables in dbspace" method	Name of the source and target dbspace (these can be the same if you want)
"Tables listed in file" method	Name of the input file for the reorganization. For more information, see Input File for Reorganizing Groups of Tables with SAPDBA.

Choose Continue.

Note

You might see a dialog box informing you that the target dbspace is not registered in the ABAP data dictionary in the R/3 System. This occurs when you have created a new dbspace – for example, using an early version of SAPDBA – which does not appear in the data dictionary. SAPDBA offers to update the data dictionary automatically for you.

SAPDBA performs the reorganization.

During the reorganization, SAPDBA keeps you informed of progress. You can abort processing by pressing Ctrl-C , but this works only between one table and the next. Every 10 tables, SAPDBA performs a checkpoint, which avoids unnecessarily large data loss if a serious fault occurs midway through processing.

Result

After a reorganization, your database is less likely to run into space problems. However, you need to keep on monitoring the tables, especially if they are growing rapidly. Refer to Analyzing Tables by Fill Level, Size, and Extents.

You must now finish the reorganization.

For more information if there are problems with the reorganization, see Reorganization Troubleshooting with SAPDBA.

See also:

Informix documentation