How can the distributed applications and/or users accessing the Db2 subsystem be seen using Detector
search cancel

How can the distributed applications and/or users accessing the Db2 subsystem be seen using Detector

book

Article ID: 197524

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

Issue/Introduction

Please provide the procedure to collect the details of users or threads using Detector for Db2 for z/OS (PDT) from distributed application
(applications running outside of LPAR) accessing the Db2 subsystem.

Resolution

Select Detector (Option DT on the DB2 Products Main Menu).  When you start a PDT collection make certain that your Dynamic SQL Stats
and Dynamic Exceptions indicators are enabled.  The details of the SQL statements that have been issued from a distributed source
will appear in Standard Activity (option 1 on the Detector Main Menu) under Plan DISTSERV.