1 to 10 of 18
Sort by

Blog Entry
Are you making the most of your Profile Tables for Db2 z/OS?

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...

Library Entry
Sample rexx code to decode DB2 accounting (SMF 101)

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.


Library Entry
Rexx to decode DB2 statistics (SMF100)

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

Blog Entry
Without a Trace - Tracing in DB2 for z/OS

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...

Denis Tronin's profile image

Library Entry
db2perf_wait.db2 - show DB2 LUW wait time percentage breakdown

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...

Steve Rees's profile image

Blog Entry
IBM Data Server Manager : Early User Experiences

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...

Philip Nelson's profile image

Blog Entry
IDUG Tech Talk: Monitoring BLU Acceleration in Depth by David Kalmuk

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...

Blog Entry
Monitoring SQL INCLUDING the content of host variables – check out the activity event monitor

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...

Library Entry
SQL Monitoring with DB2 Onboard Tools - A Comparison

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...


Library Entry
[D12] Table Monitors - Who, What, When, Where, Why and How

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...


Leo Pedron's profile image