SAP Knowledge Base Article - Preview

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


  • table with LOB column
  • Table is partitioned with range partitioning on a datetime column
  • 'ptn_locking' attribute is set to '1'
  • A daily job purges old partitions. It does "TRUNCATE TABLE ... PARTITION" and later a "ALTER TABLE ... DROP PARTITION".
  • When running "TRUNCATE TABLE ... PARTITION" command the entire table is locked regardless of the ‘ptn_locking' attribute of the table. An exclusive table lock is observed on the table.



SAP Adaptive Server Enterprise (ASE)  16.0 SP03 and above


SAP Business Technology Platform all versions


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.