SAP Knowledge Base Article - Preview

2010148 - [SAP IQ] Meaning of "Name/Userid is NULL" in sp_iqtransaction.

Symptom

We can sometimes see that the Name and Userid is (NULL) in sp_iqtransaction like below.

[SQL]

  select * from sp_iqtransaction() where Name is null and userid is null ;

Name Userid TxnID CmtID VersionID State Connhandle IQConnID ... TxnCreateTime
(NULL) (NULL) 52458621 52458626 52458626 COMMITTED 58 2714410 ... 2014-04-28 14:59:26.041


Read more...

Environment

SAP IQ 12.7 all, 15.2 all, 15.4 all, 16 all

Product

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

Keywords

sp_iqtransaction, "UserID is NULL", IQ, sybase, null, userid, connect, disconnect, transaction state, APPLIED, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

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.