Hitachi

Hitachi Advanced Database Messages


KFAA51121-W

It might take a long time to execute the SQL statement because all chunks in the archive status are accessed. (archive table name = "aa....aa"."bb....bb") (M)

Processing of the SQL statement might require a long time because the executed SQL statement accesses data in all archived chunks. The archivable multi-chunk table to be accessed is "aa....aa"."bb....bb". <SQLSTATE: 01601>

aa....aa:

Authorization identifier of the archivable multi-chunk table

bb....bb:

Table identifier of the archivable multi-chunk table

S:

Continues processing.

Action:

Consider correcting the SQL statement so that archived chunks to be accessed can be narrowed down. For details, see Considerations when searching an archivable multi-chunk table in the HADB Application Development Guide.

If this message is output during execution of the adbexport command, consider the following corrective actions.

  • When executing the adbexport command, specify the -c option (specify the chunks to be exported).

  • When executing the adbexport command, specify the -q option (specify an SQL statement file).

If you specify an SQL statement file, specify the SQL statement so that archived chunks to be accessed can be narrowed down.