-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