Client Case Study.....3

Client Case Study.....3

• We Don’t Have any Performance Problems
• We are Using Multiple Pools Already (11 Pools)
• Our Pool Performance is Good
• Total Memory Used for Pools:
  • 126 Megabytes for Virtual Pools
  • 250 Megabytes for HiperPools
• Avg. Transaction Elapsed Time .192 Secs. (475K Trans)

Previous slide

Next slide

Back to the first slide

View Graphic Version

Every DB2 system has performance problems! The only question is how severe, and how much effort is necessary to improve performance.

This person was using an online monitor to look at the buffer pools - and they only show severe or situation critical events. The pool could actually be thrashing, and the online monitors won’t show any problems unless the analyst really knows what to look for....like the ‘System Hit Ratio’.