SAP Knowledge Base Article - Preview

1955722 - Wrong description of lock_type of sp_iqlocks procedure -- SAP IQ


The below description in IQ Reference: Building Blocks, Tables, and Procedures document is wrong.

sp_iqlocks procedure does not report the below values for lock_calss.

Column Data type Description
lock_class CHAR(8)
String of characters indicating the type of lock:
  • S – share.

  • SW – share and write.

  • EW – exclusive and write.

  • E – exclusive.

  • P – phantom.

  • A – antiphantom.

  • W – write.

All locks listed have one of S, E, EW, or SW, and may also have P, A, or both. Phantom and antiphantom locks also have a qualifier of T or *:
  • T – the lock is with respect to a sequential scan.

  • * – the lock is with respect to all scans.

  • nnn – Index number; the lock is with respect to a particular index.

Sybase IQ obtains a share lock before a write lock. If a connection has exclusive lock, share lock does not appear. For write locks, if a connection has all-exclusive, share, and write locks, it is EW.



SAP Sybase IQ 15.2, 15.3, 15.4 , 16.0 and 16.0 SP01


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


sp_iqlocks, lock_type, Table, CR 748234, , KBA , BC-SYB-IQ , Sybase IQ , 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.