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.
Optimizing columnar access
Dynamic SQL statements can remain in the dynamic statement cache for a long period of time. When the statement gets refreshed, its access path could change dramatically. This article shows one way of limiting the impact of such an access path shift.
An under-appreciated set of ANSI SQL functions introduced over a decade ago could dramatically reduce application chattiness and improve response times.
We always assume that tuning, will result in actual monetary savings. Well, with IBMs Measured Workload Pricing this is not always the case. Join well known DB2 speaker Phil Grainger as he explains how IBMs MLC works in practice and what this means to our DB2 world.