Is it possible to query the Sysview for Db2 table where End User Workstation Name info is kept
search cancel

Is it possible to query the Sysview for Db2 table where End User Workstation Name info is kept

book

Article ID: 45871

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Is it possible to query the Sysview for Db2 for z/OS (IDB2) table where End User Workstation Name info is kept?

Resolution

ENDUSER-WORKSTATION is the End user's workstation name of the thread for which the storage is being reported.                                                   

This field is available on the R/HTDETL screen, the SQLTRACE request and batch request BTRECTRC. The only way to see the
ENDUSER-WORKSTATION in a table, would be to use the Archive system and load the Insight tables.

highlvl.TGTREQ(ARCIACD) is the sample extract for loading accounting data into the INSIGHT.APPLICATION_DETAIL table.