37.3.1 Reorganizing system tables

In this example, the system table STATUS_CHUNKS stored in the system-table DB area will be reorganized.

[Figure]

This example uses the following procedure to execute the adbreorgsystemdata command.

Procedure

Create a directory path file that specifies storage locations for unload files.
Execute the adbreorgsystemdata command.

Using examples, the following subsections explain each of these steps.

Organization of this subsection

(1) Creating a directory path file that specifies storage locations for unload files
(2) Executing the adbreorgsystemdata command

(1) Creating a directory path file that specifies storage locations for unload files

Create a directory path file (/home/adbmanager/reorg_file/unldpath.txt) that specifies the storage directory for unload files, and then specify the storage directory for unload files.

Example specification of the directory path file that specifies the storage locations of unload files

/home/adbmanager/unld

To Page Top

(2) Executing the adbreorgsystemdata command

adbreorgsystemdata --timeout 300                                  ...1
                   -c table                                       ...2
                   -f /home/adbmanager/reorg_file/unldpath.txt    ...3
                   -n STATUS_CHUNKS                               ...4

Explanation:

Specify 300 seconds (5 minutes) as the amount of time until the adbreorgsystemdata command times out.
Specify the target table to undergo reorganization processing.
Specify the name of the directory path file that specifies storage locations for unload files, which you created in (1) Creating a directory path file that specifies storage locations for unload files.
Specify the system table STATUS_CHUNKS as the table to be processed.

To Page Top