SQL queries passed to DB2 by Java applications

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Is it possible for Sysview for DB2 to list the SQL queries passed to DB2 by Java applications?

Environment

Z/OS   

DB2 

JAVA

Resolution

Sysview for DB2 will report the JAVA Threads as distributed application Threads in the Thread Active Report Showing as plan DISTSERV connname SERVER
e.g

Auth ID    Corr ID          Plan              ConnName  Status
xxxxxx     db2jcc_appli DISTSERV     SERVER      DDF