SAP Knowledge Base Article - Preview

2319421 - NFR for Userid be added in satmp_request_time - SAP IQ / SAP SQL Anywhere

Symptom

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:

  1. 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

  1. 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.

 


Read more...

Environment

  • SAP IQ 16 and future
  • SAP SQL Anywhere 16, 17 and future

Product

SAP IQ 16.0 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0

Keywords

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 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.