Same Delete Commands Can be executed concurrently even though delete has a same target table.
In (mixed workload, Multi-Users, Many Ad-Hoc Queries) environment, if a join delete is spending hours in searching phase before gets W-lock.
During those phase, other small delete session on the same table can be fired and finished well without any lock interruption.
Order of Delete can be important in above Environment.
SAP SYBASE IQ12.7, IQ15.2, IQ15.4 & IQ16
delete, lock, lock table, shared-lock, write-lock, write lock, shared lock, shared, SAP IQ, IQ, delete lock , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed
About this pageThis 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.