Hitachi

Hitachi Advanced Database Messages


KFAA30879-E

The index (number aa....aa in DB area "bb....bb") must be rebuilt to access the table. (M+J+O)

An attempt was made to access an index that was in unfinished status. <SQLSTATE: 40508>

aa....aa:

Index ID of the index that was in unfinished status

bb....bb:

Name of the DB area that stores the index that was in unfinished status

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:
  • If this message is output to a HADB client

    Ask the HADB administrator to check the HADB server, or contact an OS user who belongs to the HADB administrators group.

  • If this message is output to the HADB server

    If, on a table for which the target index is defined, an adbimport or adbidxrebuild command is suspended, re-execute the suspended command.

    Otherwise, re-create the index in unfinished status by using the adbidxrebuild command.

    Note that you can use an index ID as a key to identify the name of the index in unfinished status and the name of the table in which that index is defined. For details about how to do this, see Searching a dictionary table in the HADB Setup and Operation Guide.