New Feature Request for SAP IQ and SAP SQL Anywhere.
A new feature request is logged in future versions, to add "Userid" in the temporary table satmp_request_time.
This table is populated from the zrlog (Request Level Logging file) using "CALL sa_get_request_times()" .
This info is very useful for diagnosing issues and can be used for keeping regulatory information.
Currently, it is not possible know to which Userid a conn_id/conn_handle belongs, because:
- We only have the conn_id and conn_handle in the table satmp_request_time and we need to relate them to IQMSG to find the Userid.
But if the portion of IQMSG doesn't contain the time frame when the user connected, then we cannot know the user name.
Example in IQMSG:
I. 04/22 05:30:00. 0000536232 Connect: SA connHandle: 1000493417 SA connID: 125 IQ connID: 0000536232 User: DBA
- Executing sa_conn_info in SA or sp_iqconnection in IQ cannot help as both stored procedures (sprocs) don't give the conn_id/conn_handle associated with the Userid.
Also, both sprocs only display the users connected when the sprocs are executed.
If the user (that is being examined), has disconnected, then this user is not shown by the sprocs.
- SAP IQ 16 and future
- SAP SQL Anywhere 16, 17 and future
CR798891 ; 798891 ; satmp_request_time; Userid ; user name ; sa_get_request_times ; zrlog ; Request Level Logging file ; -zr ; Feature Request ; , KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this pageThis 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.