logo  
Google
 

DB2 SQL-Error: -611

SQLState: 53088

Short Description: ONLY LOCKMAX CAN BE SPECIFIED WHEN THE LOCK SIZE OF THE TABLESPACE IS TABLESPACE OR TABLE

This message is issued when: v The LOCKSIZE of the table space is TABLESPACE or TABLE, and LOCKMAX is being altered to or created as a nonzero value. v 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 executed. Programmer response: Do one of the following: v Reissue the statement with LOCKMAX 0. v Alter the LOCKSIZE of the table space to a value other than TABLESPACE or TABLE.

 <-  BACK TO INDEX