Hitachi

Hitachi Advanced Database Messages


KFAA61213-W

The number of unused segments will soon not be enough to reorganize the table "aa....aa"."bb....bb". Only cc....cc% of the segments remain unused. Execute the adbreorgsystemdata command for the table. (L+M)

The number of unused segments will soon not be enough to reorganize the table "aa....aa"."bb....bb". cc....cc% of the segments remain unused. Execute the adbreorgsystemdata command for the table "aa....aa"."bb....bb".

aa....aa:

Schema name

bb....bb:

Table identifier

cc....cc:

Percentage (50, 30, 20, or 10)

S:

Continues processing.

Action:

Execute the adbreorgsystemdata command for the table "aa....aa"."bb....bb". For details about the adbreorgsystemdata command, see adbreorgsystemdata (Reorganize System Table) in the manual HADB Command Reference.

If the number of segments used by the table "aa....aa"."bb....bb" and by the index defined for this table "aa....aa"."bb....bb" exceeds the number of unused segments, the adbreorgsystemdata command might be disabled. If the adbreorgsystemdata command cannot be executed, invalid row data continuously increases and finally, no free space will be left on the disk to store DB area files. As a result, operation that updates the system table (base table) can no longer be performed.

For details about how to reorganize the system table (base table), see Reorganizing system tables in the HADB Setup and Operation Guide.