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 Dictionary Table and 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 dictionary table (base table) or system table (base table) can no longer be performed.

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