Db2 Tools for z/OS

 View Only

SQL statement text is now available in OMEGAMON for Db2 Thread Activity workspaces in TEP and IZSME

By Suk Wong posted Fri August 06, 2021 04:57 PM


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.