Reorganize the database

• Reorganization can correct the type of error.
• The number of errors is large or the resource requirements for running the reorganization are small.

Reorganization can correct the error when it affects one of the following:

• HIDAM primary index or secondary index pointers

  The best method for correcting errors with these indexes is to rebuild them using BMC Software SECONDARY INDEX UTILITY. SECONDARY INDEX UTILITY quickly rebuilds these indexes without unloading and reloading the database. If you do not have this utility, the IBM reorganization process will rebuild them.

• Other pointer errors such PP, PTB, PCL

  The HD Unload utility uses physical child first (PCF), physical twin forward (PTF), and sometimes LP pointers to unload a database. Any broken pointers other than these types can be repaired by the reorganization process. Hierarchical forward pointers may be used instead of PCF and PTF pointers.

• Logical twin pointers

• Logical parent pointers where a symbolic pointer also exists

  You must run the reorganization using the DBIL parameter in the IMS Prereorganization utility for both the database in error and the database containing the logical parent.

• Incorrect counters

  You must run the reorganization using the DBIL parameter in the Prereorganization utility for the database containing the incorrect counter, the database containing the logical child (LC) segment, and any database containing an LP of a segment in the database in error.The following figure shows you how to reorganize using DBIL. The text immediately following the figure provides further information.

  

• DB3 has the incorrect counter and must be reorganized using DBIL parameter.
• DB1 and DB2 contain logical children (LC1 and LC2) which the counter should represent. To be matched with their logical parents and counted, they must be reorganized using the DBIL parameter.
• DB4 and DB5 both contain logical parents (LP2 and LP3) whose logical children (LC3 and LC4) are in the database in error (DB3). Since DB3 is being reorganized using DBIL parameter, DB4 and DB5 must also be reorganized using DBIL parameter.