hi Team,
i would like to know how to get the queries executed by a "C" binary which connects to the db2 database .
i tried with snapshot but i am not to proceed due to privileges.
let me know if there are sys table available to reference to.
Note: forgive me if already an answer is available , since i tried searching but unable to find it.
There are many tools for query monitoring:
[LEFT]IBM� DB2� Query Monitor for z/OS� (also referred to as DB2 Query Monitor)
provides current and historical views of query activity throughout DB2
subsystems.
These topics provide instructions for customizing and using DB2 Query Monitor.
These topics are designed to help database administrators, system programmers,
application programmers, and system operators perform these tasks:[/LEFT]
v Plan for the installation of DB2 Query Monitor
v Install and operate DB2 Query Monitor
v Customize your DB2 Query Monitor environment
v Diagnose and recover from DB2 Query Monitor problems
v Design and write applications for DB2 Query Monitor
v Use DB2 Query Monitor with other DB2 or IMS� products.
Here's another procedure:
How can trace the sql queries executed in a database (DB2) ? - Toolbox for IT Groups