-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