Topic: 2014 NA
Subtopic: DB2 for LUW
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.