Hitachi

Hitachi Advanced Database Messages


KFAA60200-W

Reorganization is recommended for the chunk with the chunk ID "aa....aa" in the table "bb....bb"."cc....cc". (E+M)

We recommend that you reorganize chunk data (chunk ID "aa....aa") in the table "bb....bb"."cc....cc".

aa....aa:

Chunk ID

bb....bb:

Schema name

cc....cc:

Table identifier

S:

Continues processing.

Action:

Performance of data retrieval from the chunk data (chunk ID "aa....aa") in the table "bb....bb"."cc....cc" might have decreased due to addition, update, or deletion repeated by SQL statements. We recommend that you reorganize chunk data (chunk ID "aa....aa") in the table "bb....bb"."cc....cc".

For details about how to reorganize data in multi-chunk tables and the causes of decreased retrieval performance, see Checking whether a multi-chunk table needs to be reorganized in the HADB Setup and Operation Guide.

For details about how to reorganize data in single-chunk tables and the causes of decreased retrieval performance, see Checking whether a single-chunk table needs to be reorganized in the HADB Setup and Operation Guide.