Articles & Content

Archives

C09 - Find the treasures of DB2 monitor data with deltas

Topic: DB2 for LUW

Subtopic: 2014



From DB2 you can get all the monitor data you ever need and store it easily into tables. The problem is that the numbers are cumulative. You often want to know how much the cumulative numbers have changed between points of time t1 and t2 – that is: you want to know the deltas.
Here's a universal method for getting the deltas. The method applies to any table with cumulative data and it does not matter how often you collect monitor data (by every n minutes or hours etc). You also get a stored procedure to automate the getting of deltas.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.