11.17.3 Reorganizing a system table
To reorganize a system table (base table), execute the adbreorgsystemdata command.
For details about the adbreorgsystemdata command, see adbreorgsystemdata (Reorganize System Table) in the manual HADB Command Reference.
- Important
-
While a system table (base table) is being reorganized, the following two datasets temporarily exist in the system-table DB area that stores the system table (base table):
-
Dataset before reorganization
-
Dataset after reorganization
Therefore, if there is not enough free disk space to store these two datasets, you cannot reorganize the system table (base table).
-
- ▪ Execution example of the adbreorgsystemdata command
-
In this example, system table (base table) STATUS_CHUNKS is reorganized. For the timeout time for the adbreorgsystemdata command, 300 seconds is specified.
adbreorgsystemdata --timeout 300 -c table -f /home/adbmanager/reorg_file/unldpath.txt -n STATUS_CHUNKS- Note
-
We recommend that you specify the --timeout option when executing the adbreorgsystemdata command.
Execution of the adbreorgsystemdata command usually finishes in several tens of seconds to a few minutes. However, if a special SQL statement or command is being executed, the adbreorgsystemdata command is placed in wait status. Therefore, execution time of the adbreorgsystemdata command might be longer. While the adbreorgsystemdata command is being executed, you cannot execute the adbimport or adbmergechunk command. For details about the wait status of the adbreorgsystemdata command, see 11.17.4 Reorganization of a system table and lock control.
If longer execution time of the adbreorgsystemdata command causes a problem in system operations, specify the --timeout option. If the adbreorgsystemdata command does not finish within the time specified for the --timeout option, the reorganization processing is canceled.
If the adbreorgsystemdata command is canceled, check the output message, and then re-execute the adbreorgsystemdata command.