13.10.10 Checking whether the column store table must be reorganized (output of information about the need for reorganization)

This example outputs the information about the need for reorganization of the specific column store table (ADBUSER01.TABLE01), and checks whether reorganization is required.

■Example of executing the adbdbstatus command

adbdbstatus -d reorginfo              ...1
            -n ADBUSER01.TABLE01      ...2
            -c 1-3                    ...3

Explanation:

1. Specifies information about the need for reorganization as the information to be output.

2. Specifies the name of the column store table (ADBUSER01.TABLE01) from which information about the need for reorganization is to be collected.

3. Specifies the chunk IDs to be analyzed (information for chunks with chunk IDs 1 to 3 will be collected).

When the adbdbstatus command is executed, information about the need for reorganization for table ADBUSER01.TABLE01 is output.

Use the following procedure to determine whether each chunk must be reorganized based on the output results.

Procedure

1. Check the chunk IDs.

   Confirm that the chunk IDs are output in the Chunk_ID column (column 8 in the output results).

2. Check whether each chunk must be reorganized.

   If a chunk must be reorganized, Recommended is output in the Reorganization_necessity column (column 14 in the output results). In this case, the KFAA60200-W message that recommends reorganization of the relevant chunk is also output.

   For details about how to reorganize a column store table, see Reorganizing a single-chunk table or Reorganizing a multi-chunk table: Chunk-based reorganization in the HADB Setup and Operation Guide.

To Page Top