Over the years DB2 buffer pools have dramatically increased in size to support ever increasing DB2 workloads. It is common today for DB2 installations to have multiple DB2 subsystems/members, each with several large buffer pools.
We all know the importance of avoiding Prepares in dynamic SQL. But performance tuning often involves balancing one cost against another, so are there are times when incurring a Prepare cost is justified in the bigger picture? There might be cases where this is true, but if you don’t measure ...
This month on the Content Committee blog we have focused on “Fun with SQL” dojo. Each week we’ve presented an SQL challenge and requested the community to solve it. Today we announce the winners of the random drawing
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 presentation wi
For the past 30 years, our focus as DB2 for z/OS database administrators has been on the support of COBOL programs with static queries that were relatively easy to control as they were identical throughout the business logic. Static SQL provided persisted access paths in the database s