SAP Knowledge Base Article - Preview

3238488 - Truncating a table partition with off-row LOB data causes an exclusive table lock - SAP ASE

Symptom

  • Table is partitioned with range partitioning on a datetime column;
  • Table with LOB column;
  • The 'ptn_locking' attribute is set to '1';
  • A daily job purges old partitions:

TRUNCATE TABLE ... PARTITION
...
ALTER TABLE ... DROP PARTITION

  • When running the "TRUNCATE TABLE ... PARTITION" command, the entire table is locked regardless of the ‘ptn_locking' table attribute. An exclusive table lock is observed on the table.


Read more...

Environment

SAP ASE 16.0 SP03 and above

Product

SAP Business Technology Platform all versions

Keywords

truncate partition, ptn_locking, partition locking, exclusive lock, Ex_table-blk, 827053 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.