Wednesday, November 9, 2011

Monitoring: Three new for three old monitoring functions

I was reading over the list of new, deprecated and discontinued functionality after DB2 9.7 Fixpack 5 has been made available. What I found interesting is that 3 old snapshot monitoring table functions and their related views are now listed as deprecated which means they may be removed in a future release. Many of you know that DB2 9.7 introduced new, more lightweight monitoring functions.

I am not working in DB2 development anymore, but know that maintaining two sets of functions, especially in critical areas like memory management, can be a pain. Marking the old functions as deprecated in a fixpack seems like they will be gone sooner than later. What does it mean for you? Get ready to explore and exploit the new monitoring if you are not already on them. They also integrate well with workload management.