Over the years as Db2 has traded real storage exploitation for CPU and zIIP MIPS reductions, customers have become more aggressive at utilizing these techniques. Db2 buffer pool expansion, EDM and authorization cache pools, as well as persisting threads through the use of KEEPDYNAMIC and RELEASE...
With the flattening of Moore's Law, processor speeds will not serve as a significant source of performance improvement in coming years. Database systems are looking to exploit large real memory to avoid I/O latency and CPU overhead. DB2 10 and future releases of DB2 will look to exploit large...
EU13A11.pdf
This session will introduce and discuss the most common issues and topics around real world customer usage of DB2 10 for z/OS. Specifically this will include: real storage control, online release migration in 24*7 environment, steps to investigate CPU performance, OPTIMIZE FOR 1 ROW, OPTIOWGT...
EU13A05.pdf