When optimizing information is registered, updated, or deleted, the updated content of the applicable table is committed separately for table information, column information, and index information. Consequently, if an error occurs while optimizing information is being registered, updated, or deleted (with the return code in the KFPN00011-I message being 8), information that has not been committed is rolled back, and the optimizing information might not be changed accurately. In this case, remove the cause of the error by following the instructions given in the KFPN00011-I message, and then re-execute the command until the return code becomes 0. If the error persists even when you re-execute the command, take the corrective action described in the following table and return the optimizing information to the state it was in before registration, updating, or deletion:

Operation being performed when the error occurred	Corrective action
Optimizing information registration	Delete the optimizing information. For details, see 19.2.4 Deleting optimizing information.
Optimizing information updating	Restore the optimizing information. For details, see 19.2.3 Restoring optimizing information.
Optimizing information deletion

You can check the processing type in the KFPN00013-I message to identify the operation that was being performed when the error occurred. Even when you register or update optimizing information, unless the KFPN00013-I message is output, the information has not been changed. Therefore, you need not take the corrective action described above. When you delete optimizing information, do take the corrective action described above.