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

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

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