![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
If reloading results in an error during table reorganization, eliminate the cause of the error and then re-execute table reorganization (-k rorg).
If table reorganization results in an error, the table is placed in under-reorganization status. If table reorganization is re-executed while the table's status is under-reorganization, processing is restarted with the process that resulted in the error. To determine whether or not the corresponding RDAREA was being reorganized, execute pddbst's logical analysis in units of RDAREAs or analysis in units of tables and then check Status in the analysis results.
In the event of an error during table reorganization, Table 8-7 Restart location when table reorganization is re-executed due to an error (when only LOB column structure base table or both LOB column structure base table and LOB column are reorganized (-j specified)) describes the location where table reorganization is restarted. Reorganization of a LOB column structure base table only or together with a LOB column is based on the assumption that the -j option is specified and a single unload data file is used.
Table 8-7 Restart location when table reorganization is re-executed due to an error (when only LOB column structure base table or both LOB column structure base table and LOB column are reorganized (-j specified))
| No. | Processing during table reorganization | Output message immediately before error# | Table status | Restart location | ||||
|---|---|---|---|---|---|---|---|---|
| LOB column structure base table | LOB column | LOB attribute | ||||||
| 1 | Unloading | Starting unloading | 712, 732 | -- | -- | -- | No. 1 | |
| 2 | Completing unloading | 714, 734 | rc=8 | -- | -- | -- | No. 1 | |
| rc=0 | N and R | N and R | N and R | For falsification prevented table: No. 3 |
||||
| R | R | R | For table other than falsification prevented table: No. 1 (in units of tables or RDAREAs) No. 3 (in units of schemas) |
|||||
| 3 | Reloading | Starting data deletion | Not output | N and R | N and R | N and R | For falsification prevented table: No. 3 |
|
| R | R | R | For table other than falsification prevented table: No. 1 (in units of tables or RDAREAs) No. 3 (in units of schemas) |
|||||
| 4 | Completing data deletion | 721 | N and R | N and R | N and R | No. 5 | ||
| 5 | Starting reloading | 712, 732 | N and R | N and R | N and R | No. 5 | ||
| 6 | Completing reloading | 714, 734 | rc=8 | N and R | N and R | N and R | No. 5 | |
| rc=0 | R | R | R | When index has been defined and -i c is specified: No. 7 Other than the above: No. 1 |
||||
| 7 | Batch index creation | Starting index unloading (during restart only) | 725 | R | R | R | No. 7 | |
| 8 | Starting batch index creation | 715 | R | R | R | No. 7 | ||
| 9 | Completing batch index creation | 716 | R | R | R | When there is an index that has not been created: No. 7 |
||
| -- | -- | -- | Other than the above: No. 1 |
|||||
In the event of an error during table reorganization, Table 8-8 Restart location when table reorganization is re-executed due to an error (when only LOB column structure base table or both LOB column structure base table and LOB column are reorganized (lobunld statement specified)) describes the location where table reorganization is restarted. Reorganization of a LOB column structure base table only or together with a LOB column is based on the assumption that the lobunld statement is specified and an unload data file and LOB data unload data file are used.
Table 8-8 Restart location when table reorganization is re-executed due to an error (when only LOB column structure base table or both LOB column structure base table and LOB column are reorganized (lobunld statement specified))
| No. | Processing during table reorganization | Output message immediately before error# | Table status | Restart location | ||||
|---|---|---|---|---|---|---|---|---|
| LOB column structure base table | LOB column | LOB attribute | ||||||
| 1 | Unloading LOB column structure base table | Starting unloading | 712, 732 | -- | -- | -- | No. 1 | |
| 2 | Completing unloading | 714, 734 | rc=8 | -- | -- | -- | No. 1 | |
| rc=0 | N and R | N and R | N and R | For falsification prevented table: No. 3 |
||||
| R | R | R | For table other than falsification prevented table: No. 1 |
|||||
| 3 | Reloading to LOB column structure base table | Starting data deletion | Not output | N and R | N and R | N and R | For falsification prevented table: No. 3 |
|
| R | R | R | For table other than falsification prevented table: No. 1 |
|||||
| 4 | Completing data deletion | 721 | N and R | N and R | N and R | No. 5 | ||
| 5 | Starting reloading | 712, 732 | N and R | N and R | N and R | No. 5 | ||
| 6 | Completing reloading | 714, 734 | rc=8 | N and R | N and R | N and R | No. 5 | |
| rc=0 | R | R | R | When index has been defined and -i c is specified: No. 7 Other than the above: No. 1 |
||||
| 7 | Batch index creation | Starting index unloading (during restart only) | 725 | R | R | R | No. 7 | |
| 8 | Starting batch index creation | 715 | R | R | R | No. 7 | ||
| 9 | Completing batch index creation | 716 | R | R | R | When there is an index that has not been created: No. 7 Other than the above: No. 10 |
||
| 10 | Unloading LOB column | Starting unloading | 712, 732 | R | R | R | No. 10 | |
| 11 | Completing unloading | 714, 734 | rc=8 | R | R | R | No. 10 | |
| rc=0 | R | N and R | R | For falsification prevented table: No. 12 |
||||
| R | R | R | For table other than falsification prevented table: No. 10 |
|||||
| 12 | Reloading LOB column | Starting data deletion | Not output | R | N and R | R | For falsification prevented table: No. 12 |
|
| R | R | R | For table other than falsification prevented table: No. 10 |
|||||
| 13 | Completing data deletion | 721 | R | N and R | R | No. 14 | ||
| 14 | Starting reloading | 712, 732 | R | N and R | R | No. 14 | ||
| 15 | Completing reloading | 714, 734 | rc=8 | R | N and R | R | No. 14 | |
| rc=0 | -- | -- | -- | No. 1 | ||||
In the event of an error during table reorganization, Table 8-9 Restart location when table reorganization is re-executed due to an error (when LOB column only is reorganized) describes the location where table reorganization is restarted.
Table 8-9 Restart location when table reorganization is re-executed due to an error (when LOB column only is reorganized)
| No. | Processing during table reorganization | Output message immediately before error# | Table status | Restart location | ||||
|---|---|---|---|---|---|---|---|---|
| LOB column structure base table | LOB column | LOB attribute | ||||||
| 1 | Unloading LOB column | Starting unloading | 712, 732 | -- | -- | -- | No. 1 | |
| 2 | Completing unloading | 714, 734 | rc=8 | -- | -- | -- | No. 1 | |
| rc=0 | -- | N and R | -- | For falsification prevented table: No. 3 |
||||
| -- | R | -- | For table other than falsification prevented table: No. 1 |
|||||
| 3 | Reloading LOB column | Starting data deletion | Not output | -- | N and R | -- | For falsification prevented table: No. 3 |
|
| -- | R | -- | For table other than falsification prevented table: No. 1 |
|||||
| 4 | Completing data deletion | 721 | -- | N and R | -- | No. 5 | ||
| 5 | Starting reloading | 712, 732 | -- | N and R | -- | No. 5 | ||
| 6 | Completing reloading | 714, 734 | rc=8 | -- | N and R | -- | No. 5 | |
| rc=0 | -- | -- | -- | No. 1 | ||||
In the event of an error during table reorganization, Table 8-10 Restart location when table reorganization is re-executed due to an error (reorganization in units of schemas) describes the location where table reorganization is restarted.
Table 8-10 Restart location when table reorganization is re-executed due to an error (reorganization in units of schemas)
| No. | Processing during table reorganization | Timing | Restart location |
|---|---|---|---|
| 1 | Unloading | When an error occurred during unloading | No. 1 |
| 2 | Reloading | When an error occurred after the KFPL00722-I message was issued | No. 2 |
For a HiRDB parallel server configuration, if reloading results in an error during reorganization of a table that is split among multiple servers, reorganization is restarted at the location indicated in (a) through (c) for each server where the unload and lobunld statements are specified in the control information file.
If reloading results in an error during table reorganization or reorganization is incomplete for a reason such as an error during reorganization of a falsification prevented table, the target RDAREA is placed in reload-not-completed data status. In such a case, execution of some commands and SQL statements is restricted.
Table 8-11 Whether utilities can be executed on a table in reload-not-completed data status describes whether or not utilities can be executed on a table that is in reload-not-completed data status, Table 8-12 Whether operation commands can be executed on a table in reload-not-completed data status describes whether or not operation commands can be executed on such a table, and Table 8-13 Whether SQL statements can be executed on a table in reload-not-completed data status describes whether or not SQL statements can be executed on such a table.
Table 8-11 Whether utilities can be executed on a table in reload-not-completed data status
| Utility name | Function | Table status | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| B: -- | B: RN | B: -- | B: -- | B: RN | B: RN | B: -- | B: N | ||||
| A: -- | A: -- | A: RN | A: -- | A: RN | A: -- | A: RN | A: N | ||||
| L: -- | L: -- | L: -- | L: RN | L: -- | L: RN | L: RN | L: N | ||||
| pdload | Data loading on LOB column structure base table | -d specified | Y | Y | Y | Y | Y | Y | Y | Y | |
| -d omitted | Y | N | N | N | N | N | N | N | |||
| Data loading on LOB column | Y | N | N | N | N | N | N | N | |||
| Concurrent data loading on LOB column structure base table and LOB column | -d specified | Y | Y | Y | Y | Y | Y | Y | Y | ||
| -d omitted | Y | N | N | N | N | N | N | N | |||
| pdrorg | Table reorganization (-k rorg) | -j specified | unload statement | Y | C | C | C | C | C | C | C |
| -j omitted | unload statement | Y | C | C | C | C | C | C | C | ||
| lobunld statement | Y | C | C | C | C | C | C | C | |||
| unload statement and lobunld statement | Y | C | C | C | C | C | C | C | |||
| Unloading table (-k unld) | Y | Y | Y | Y | Y | Y | Y | Y | |||
| Table reloading (-k reld) | -j specified | unload statement | Y | Y | Y | Y | Y | Y | Y | Y | |
| -j omitted | unload statement | Y | Y | Y | Y | Y | Y | Y | Y | ||
| lobunld statement | Y | Y | Y | Y | Y | Y | Y | Y | |||
| unload statement and lobunld statement | Y | Y | Y | Y | Y | Y | Y | Y | |||
| Batch index creation (-k ixmk) | B-tree index | Y | N | N | N | N | N | N | N | ||
| Plug-in index | Y | N | N | N | N | N | N | N | |||
| Index re-creation (-k ixrc) | B-tree index | Y | N | N | N | N | N | N | N | ||
| Plug-in index | Y | N | N | N | N | N | N | N | |||
| Index reorganization (-k ixor) | Y | N | N | N | N | N | N | N | |||
| pdrbal | Y | N | N | N | N | N | N | N | |||
| Other utility | Y | Y | Y | Y | Y | Y | Y | Y | |||
Table 8-12 Whether operation commands can be executed on a table in reload-not-completed data status
| Operation command name | Condition | Table status | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| B: -- | B: RN | B: -- | B: -- | B: RN | B: RN | B: -- | B: RN | |||
| A: -- | A: -- | A: RN | A: -- | A: RN | A: -- | A: RN | A: RN | |||
| L: -- | L: -- | L: -- | L: RN | L: -- | L: RN | L: RN | L: RN | |||
| pdrels | RDAREA containing falsification prevented table | B | Y | N | Y | Y | N | N | Y | N |
| A | Y | Y | N | Y | N | Y | N | N | ||
| L | Y | Y | Y | N | Y | N | N | N | ||
| Other RDAREA | Y | Y | Y | Y | Y | Y | Y | Y | ||
| Other operation command | Y | Y | Y | Y | Y | Y | Y | Y | ||
Table 8-13 Whether SQL statements can be executed on a table in reload-not-completed data status
| SQL | Table status | |||||||
|---|---|---|---|---|---|---|---|---|
| B: -- | B: RN | B: -- | B: -- | B: RN | B: RN | B: -- | B: RN | |
| A: -- | A: -- | A: RN | A: -- | A: RN | A: -- | A: RN | A: RN | |
| L: -- | L: -- | L: -- | L:RN | L: -- | L:RN | L:RN | L:RN | |
| SELECT statement | Y | Y | C | C | C | C | C | C |
| UPDATE statement | Y | Y | C | C | C | C | C | C |
| INSERT statement | Y | Y | C | C | C | C | C | C |
| DELETE statement | Y | Y | C | C | C | C | C | C |
| Other SQL statement | Y | Y | Y | Y | Y | Y | Y | Y |
The reload-not-completed data status is released at the following times:
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.