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, CR748234, 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 for Me (Login required).

Search for additional results

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