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.
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
The BLU Acceleration Technology introduced in DB2 10.5 brings with it a host of new monitoring considerations and metrics. This session will introduce you to the new monitoring capabilities that support BLU Acceleration and through practical examples will show you how you can leverage these in your
When the DB2 HADR feature is enabled, the primary database's transaction logs are replicated to one or more standby databases in real time. The replication provides HA and DR protection, at a cost. The replication adds overhead to the primary's log writing.
Martin Hubel continues the coverage of new features of DB2 for LUW with an analysis of expression-based indexes -