-611   ONLY LOCKMAX 0 CAN BE SPECIFIED WHEN THE LOCK SIZE OF THE TABLESPACE IS TABLESPACE OR TABLE

Explanation

This message is issued when:
  • The LOCKSIZE of the table space is TABLESPACE or TABLE, and LOCKMAX is being altered to or created as a nonzero value.
  • The LOCKSIZE of the table space is being altered to TABLESPACE or TABLE, and LOCKMAX is being altered to or created as a nonzero value.

If LOCKSIZE is TABLESPACE or TABLE, LOCKMAX must be 0 because lock escalation is not supported from these levels.

System action

The statement cannot be processed.

Programmer response

Do one of the following:
  • Reissue the statement with LOCKMAX 0.
  • Alter the LOCKSIZE of the table space to a value other than TABLESPACE or TABLE.

SQLSTATE

53088