• 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 index to make sure that the reorganization is necessary. Refer to Analyzing Index Information with SAPDBA.
• You want to use the same fill factor for all the indexes of a table. If this is not true, see Reorganizing a Single Index with SAPDBA, which lets you specify an individual fill factor for each index.

1. Choose Reorganization ® Reorganize Index(es) ® All Indexes of one Table in SAPDBA for Informix.
2. In table name, enter data as required. If you do not know the name of the table for which you want to reorganize the indexes, you can use a partial entry (for example, a0*) and SAPDBA lists the matching tables.
3. If you want to analyze the table information again before you reorganize, choose Table Information.
4. Choose Continue.

SAPDBA displays a set of parameters specifying the reorganization.

5. Enter the fill factor.

This parameter specifies the fill level of the indexes when reorganized. Set it as follows:

- If the underlying table is dynamic (that is, a lot of new data is being added) specify a low fill factor.

- If the underlying table is static (that is, little new data is being added) specify a high fill factor.

The value initially displayed is a default which you can find in the ONCONFIG file:

FILLFACTOR 90 # Fill factor for building indexes

You can use SAPDBA to view the ONCONFIG file. Refer to Listing System Information with SAPDBA. The file is called onconfig.<hostname>.<sid> and you can find it in the directory $INFORMIXDIR/etc .

6. Enter the value for 'detach' index in dbspace.

This parameter specifies whether the reorganized indexes remain in the same dbspace. You can enter a new dbspace if you want to detach the indexes and store them in a separate dbspace.



To reorganize the indexes, SAPDBA needs to lock them. Therefore, it is best to reorganize when the R/3 System is down, to avoid performance problems. You might also experience unpredictable results if the indexes you are trying to reorganize are locked by another process.

7. Choose Continue to reorganize the indexes.

After an index reorganization, your database is less likely to run into space problems. However, you need to keep on monitoring the index, especially if the underlying table is growing rapidly. Refer to Storage Analysis of Tables and Indexes with SAPDBA.