-240 THE PARTITION CLAUSE OF A LOCK TABLE STATEMENT IS INVALID
Explanation
The LOCK TABLE statement is invalid for one of the following reasons:
- If it is partitioned, specify a PARTITION 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.
- If it is partitioned and defined with LOCKPART YES, specify a PART clause that identifies the partition you want to lock.
- 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.
- If it is not partitioned, do not specify the PART clause.
SQLSTATE
428B4