This section explains the actions that can be taken when an error occurs during index reorganization and the pdrorg command terminates abnormally. The operational procedure after the pdrorg command has terminated abnormally is explained below.

Procedure

To perform corrective actions:

1. Check if the KFPL00715-I message has been output to the message log file or the syslogfile. This message indicates that index loading has started; if it has been output, an index information file has been created.
2. If the KFPL00715-I message has not been output, execute the pdrorg command (index reorganization) again. However, in the case of abnormal termination due to entry of the pdcancel command, for example, the index key information might have been lost, rendering re-execution of index reorganization impossible. In such a case, execute index re-creation (-k ixrc specification).
3. If the KFPL00715-I message has been output, perform the following operation using the created index information file as the input file:

• When index reorganization is being executed in a mode other than the no-log mode:
  Use the pdrorg command to create the index in the batch mode(-k ixmk specification).
  
• When index reorganization is being executed in the no-log mode:
  The RDAREAs that store the index are in error shutdown status, so their error shutdown status must be released by using the pdmod command to reinitialize the RDAREAs. Then use the pdrorg command to re-create the index (-k ixrc specification).
  

Notes

One of the common errors that might occur during index reorganization is a space shortage in an RDAREA storing the index. The actions to be taken in such a case are explained in 14.1.4 Example 2: When an RDAREA shortage occurs during index reorganization (execution in a mode other than no-log mode) and 14.1.5 Example 3: When an RDAREA shortage occurs during index reorganization (execution in no-log mode).

However, if a value other than 0 was specified in the PCTFREE operand during index definition, specifying the idxfree operand in the option statement of the pdrorg command might be sufficient without having to expand the index-storage RDAREA.