With the ever increasing number of features and functions being added to Db2 for z/OS it’s easy to overlook the finer points of some of those features. Take in point the “Profile Tables”. You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set...
Not all fields are processed , but a good start that you can use to adapt it to your needs The rexx can only process 1 date/lpar/ssid at a time. SMF records should be selected/narrowed by IFASMFDP before JCL and rexx source code provided.
print.txt
Steps to do : - Submit IFASMFDMP to extract SMF100 (jcl not provided) - Submit the provided JCL100 which will sort the SMF dataset and give it as input to the program REX100 Note : Modify REX100 : 1- To change the input and output datasets according to your site 2- Modify the SSID ...
2 attachments
Tracing is one of the strongest, but least understood, mechanisms available to you with DB2. It gives you the ability to lift up the hood, helping you determine what is going wrong and why. So don’t be lost for answers when DB2 hangs or consumes to many resources, start tracing. This...
The Time Spent hierarchy in DB2 LUW is a great way to understand where your system is busy or where it's waiting, and more metrics are added to it on a regular basis. This script captures the entire DB2 10.5 wait time hierarchy, showing by % where time is spent. It uses delta...
Introduction IBM released the initial version of Data Server Manager (DSM) on Friday March 20 th 2015. DSM is IBM's new delivery mechanism for monitoring, tuning and administration of IBM database environments. It is available initially only for DB2 for LUW, supporting all currently...
2 Comments - no search term matches found in comments.
The BLU Acceleration Technology introduced in DB2 10.5 brings with it a host of new monitoring considerations and metrics. This session will introduce you to the new monitoring capabilities that support BLU Acceleration and through practical examples will show you how you can leverage these in...
In DB2 9.5 for Linux, UNIX and Windows the Workload Management Feature (WLM) was introduced. Besides the obvious capability of managing workloads it added a whole bunch of new monitoring possibilities. These new options provide great ability to focus database monitoring on the really important...
How could I track my SQL statements? This question is adressed in a number of ways in this speech. DB2 LUW offers a lot of tools - like Snapshot Monitor, new and old Event Monitors, Administrative Views and even more - that come with the database product. It will not only be shown how to use...
EU13D14.pdf
Snapshot monitoring, you know it and you love it. But in DB2 10 is has been deprecated. They are still there, but it’s time to move on to new and better methods. That’s where the table monitoring functions come in. These functions have all the good stuff you know and love, plus they give...
EU13D12.pdf