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.