Nonstop Database, HiRDB Version 9 Command Reference
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
10.7 Error handling procedures
- If pdrbal's return code is 8, check the error message, correct the error, then re-execute pdrbal.
- If the KFPL33003-I message (STATUS=END) is displayed during the execution of pdrbal, table rebalance processing has terminated normally. Therefore, once this message is issued, there is no need to re-execute pdrbal, even if an error occurs thereafter.
- If an error occurs during batch index creation in the exclusive mode (return code = 8), eliminate the cause of the error and then execute batch index creation (-k ixmk) using pdrorg along with the index information files for the index that resulted in an error. Then, execute pdrbal.
- If the KFPL15240-E message (memory shortage) is issued while a compressed table is being rebalanced in the shared mode, and if you can allocate the required memory in the shared mode, re-execute the utility in the shared mode. For details about the memory capacity required for execution, see the HiRDB Version 9 Installation and Design Guide.
- If rollback occurs during the execution of pdrbal, the action to be taken depends on the log acquisition method (-l option). The table below the action to be taken in the event of rollback during execution of pdrbal.
Table 10-13 Action to be taken in the event of a rollback during the execution of pdrbal
| Log acquisition method (-l option) |
pdrbal processing |
| Rebalancing |
Batch index creation (exclusive mode) |
| a |
Database status |
The row data that was rolled back has not been moved. The preceding row data have already been moved. |
Index is placed in unfinished status. |
| Action |
Re-execute pdrbal. |
Execute batch index creation (-k ixmk) using pdrorg. In this case, use the index information files that resulted in an error. |
| n |
Database status |
There is no guarantee. |
There is no guarantee. |
| Action |
Restore the database from its backup copy, then re-execute pdrbal. |
Reinitialize the corresponding index storage RDAREAs and re-create the index (-k ixrc) using pdrorg. |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.