Hitachi

Hitachi Advanced Database Messages


KFAA31654-E

The maximum number of chunks of a table without the CHUNK option specified cannot be changed. (M+J+O)

The maximum number of chunks was not specified in the chunk specification when the base table was defined by using the CREATE TABLE statement. Therefore, the ALTER TABLE statement cannot be used to change the maximum number of chunks. <SQLSTATE: 42IAD>

S:

Ignores this SQL statement.

Action:

If you want to specify the maximum number of chunks, delete the table definition and then re-define the table. For details about the procedure, see Changing a single-chunk table to a multi-chunk table in the HADB Setup and Operation Guide.

If you do not need to specify the maximum number of chunks, delete the specification of the maximum number of chunks and then re-execute the ALTER TABLE statement.