When you are analyzing a Db2 thread performance from IBM® OMEGAMON® for Db2 Performance Expert on z/OS using Tivoli Enterprise Portal (TEP) or IBM Z Service Management Explorer (IZSME) user interface, you can now view statement text for static and dynamic SQL without additional user interface. You simply click the HTML link “Thread SQL Statement Text” to view the SQL statement.
You can also get to “Thread SQL Statement Text” from other Thread Activity workspaces like “All Threads Connected to DB2”.
TEP user interface
IZSME user interface
Apply this maintenance to get SQL statement text
Fixpack 5.4.0-TIV-KD5-FP0021 and PTF UI75713 (APAR PH37634). Please note that if you are using Self Describing Agent (SDA), you don’t need to install the fixpack.#IBMZ#OMEGAMON#Db2z/OS