SAP Knowledge Base Article - Preview

1926608 - [SAP SYBASE IQ] Same Deletes which have a same target table can be executed concurrently.

Symptom

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.


Read more...

Environment

SAP SYBASE IQ12.7, IQ15.2, IQ15.4 & IQ16

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

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 page

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

Search for additional results

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