Nonstop Database, HiRDB Version 9 Command Reference
The table below shows the status of the database and recovery method in the event of an error during index reorganization.
Table 8-48 Status of database and recovery method in the event of error during index reorganization
| -l option | Status/Recovery method | Message output immediately before error occurred | ||||
|---|---|---|---|---|---|---|
| None | 725 | 715 | 716 | |||
| a or p | Status | Status before execution | Status before execution | Index not created | Index creation completed | |
| Recovery | Re-execute reorganization | Re-execute reorganization | Execute batch creation# | Unnecessary | ||
| n | Status | Table | Status before execution | Status before execution | Status before execution | Status before execution |
| Index | Status before execution | Status before execution | Not guaranteed | Creation completed | ||
| Recovery | Table | Unnecessary | Unnecessary | Unnecessary | Unnecessary | |
| Index | Re-execute reorganization | Re-execute reorganization | Re-execute batch creation after recovering database# | Unnecessary | ||
#: If you recovered the index storage RDAREA by re-initializing the RDAREA instead of using its backup copy, re-execute the index re-creation.
All Rights Reserved. Copyright (C) 2014, Hitachi, Ltd.