-4732   THE MAXIMUM NUMBER OF ALTERS ALLOWED HAS BEEN EXCEEDED FOR object-type

Explanation

The ALTER statement cannot be processed because the maximum number of alters for the object has already been exceeded. This can occur for the following reasons:
  • The SET DATA TYPE keyword was specified on an ALTER TABLE ALTER COLUMN statement, but the maximum number of ALTER statements for this table has already been reached.
  • The statement attempts to alter an index, but the maximum number of ALTER statements for this index has already been reached.

System action

The statement cannot be processed.

Programmer response

Run MODIFY to instruct DB2® that copies of a certain age will no longer be employed in recovery, and versions that are used only in those copies can be reused.

SQLSTATE

54055