logo  
Google
 

DB2 SQL-Error: -240

SQLState: 428B4

Short Description: THE PART CLAUSE OF A LOCK TABLE STATEMENT IS INVALID

The LOCK TABLE statement is invalid for one of the following reasons: v If it is partitioned, specify a PART clause that identifies the partition you want to lock.System action: The LOCK TABLE statement cannot be executed. Programmer response: Determine whether the specified table resides in a partitioned table space defined with LOCKPART YES. v If it is partitioned and defined with LOCKPART YES, specify a PART clause that identifies the partition you want to lock. v If it is partitioned but does not have the LOCKPART YES attribute and you want to lock a single partition, use ALTER TABLESPACE to change the LOCKPART attribute to YES. v If it is not partitioned, do not specify the PART clause.

 <-  BACK TO INDEX