13.9.2 List of items that are output as information about the need for reorganization

The following table lists the titles of the items (columns) that are output as the information about the need for reorganization, and the content that is output. The columns are output in the order listed in the table. For details about the columns that are output in the information about the need for reorganization, see 13.12 Output rules for the adbdbstatus command.

Table 13‒23: Columns output in the information about the need for reorganization
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of information that is output: `Reorg_info`: Information about the need for reorganization	N
2	`Timestamp`	Timestamp when the `adbdbstatus` command was executed: The date and time the `adbdbstatus` was executed are output in the following format: `"YYYY-MM-DD`∆`hh:mm:ss"`^#1	Y
3	`DBarea_name`	Name of the DB area where the table is stored	Y
4	`DBarea_ID`	DB area ID of the DB area where the table is stored	N
5	`Schema_name`	Table schema name	Y
6	`Table_identifier`	Table identifier	Y
7	`Table_ID`	Table ID	N
8	`Chunk_ID`	Chunk ID	N
9	`Column_data_num`	Number of rows in column store format The total of the following values is output: Number of rows imported into a column-data segment by the `adbimport` command Number of rows converted in column store format by the updated-row columnizing facility	N
10	`Base_row_pages`^#2	Number of basic row pages contained in the row-data segment^#3^{, #4}	N
11	`Branch_row_pages`^#2	Number of branch row pages contained in the row-data segment^#3	N
12	`Invalid_row_information_pages`^#2	Number of invalid row information pages contained in the row-data segment^#3	N
13	`Reorganization_necessity_index`	Troubleshooting information	N
14	`Reorganization_necessity`	Necessity of reorganization `Recommended`: Reorganization is recommended. `Not_recommended`: Reorganization is not recommended. If performance of chunk retrieval might have decreased, `Recommended` is output. In this case, the `KFAA60200-W` message that recommends reorganization is also output for each chunk. For details about the reasons why a column store table must be reorganized and how to do so, see the following in the HADB Setup and Operation Guide: Checking whether a single-chunk table needs to be reorganized or Checking whether a multi-chunk table needs to be reorganized.	N

Legend:

Y: The output value is enclosed in a pair of enclosing characters.

N: The output value is not enclosed in the enclosing character.

#1

The year (YYYY) is output in 4 digits. The month (MM), date (DD), hours (hh), minutes (mm), and seconds (ss) are each output in 2 digits. If there are not enough digits, leading zeros are added. Δ indicates a single-byte space.

#2

If the display units for information about the need for reorganization is changed by using the -S option, the column titles for the output items are also changed to match the selected display units. For details about the display units and column titles, see Table 13‒14: Display units and column titles for the output items for the necessity of reorganization in (2) Explanation of options in 13.2.2 Explanation of the specification format and options (outputting information about the need for reorganization of column store tables).

#3

The -S option enables you to change the display units for information about the need for reorganization to kilobytes, megabytes, or gigabytes.

#4

If basic row pages are made reusable by the updated-row columnizing facility, the number of pages that have become reusable is excluded from the displayed Base_row_pages value (number of basic row pages contained in the row-data segment).

When the pages that have become reusable are reused and filled to capacity, the number of reused pages is added again to the displayed Base_row_pages value (number of basic row pages contained in the row-data segment).

For details about the updated-row columnizing facility, see Using the updated-row columnizing facility (maintaining the retrieval performance for column store tables) in the HADB Setup and Operation Guide.

To Page Top