IBM DB2 Community

IBM DB2 Blog

Robert Catterall
Follow /24 May 2018 at 9:50pm / IBM DB2 Blog

Db2 for z/OS Buffer Pools: Index Root Pages and the Data Management Threshold

Sometimes, a change in the way Db2 for z/OS manages its resources is introduced, and the change "flies under the radar" (i.e, it escapes the notice of most Db2 users) because it is relatively small in terms of scope and impact and is not widely...
4 0 /
Robert Catterall
Follow /30 Apr 2018 at 1:59pm / IBM DB2 Blog

Db2 for z/OS Buffer Pools - Time to Give AUTOSIZE(YES) a Try?

Db2 9 for z/OS became generally available back in 2007. In the years since, most of the features introduced with Db2 9 have been broadly put to use. An interesting exception is the auto-sizing of buffer pools, implemented via the AUTOSIZE(YES) option...
42 0 /
Robert Catterall
Follow /2 Apr 2018 at 1:59pm / IBM DB2 Blog

Another Db2 for z/OS Blog You Should Check Out

If you're reading this, it's probably because you've found blogs to be a useful source of technical Db2 for z/OS information. I want to direct your attention to one of the newer kids on the Db2 blog block: Db2 for z/OS News from the Lab ....
79 0 /
Robert Catterall
Follow /29 Mar 2018 at 6:07am / IBM DB2 Blog

Db2 for z/OS: CACHEPAC is Another ZPARM You Should Check

Sometimes, the default value of a Db2 ZPARM parameter is changed to reflect new realities of Db2 workloads and of systems on which Db2 for z/OS runs. When that happens, a Db2-using organization may stick with the old default value for the ZPARM, and going...
71 0 /
Robert Catterall
Follow /26 Feb 2018 at 2:14pm / IBM DB2 Blog

Db2 for z/OS: DDF, zIIP Engines, and SMT2

SQL statements executed by way of the Db2 for z/OS distributed data facility (DDF) are not, of course, the only workload that uses zIIP MIPs, but in my experience this does tend to be the main driver of zIIP utilization in a z/OS system on which Db2 runs...
157 0 /