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

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.