IBM Systems Magazine, Mainframe Edition - January/February 2011 - 42

Tips and Techniques
Tactical solutions

DB2 10 Conversion Mode
Reduce resource consumption on DB2 10 for z/OS
By Jeff Berger

C

ompanies can utilize the Conversion Mode of DB2* 10–a mode in which it’s still possible to fall back to the prior release–to reduce DB2 resource consump-

tion. Conversion Mode is the state DB2 is in when you first migrate from DB2 8 or 9. During migration, you won’t be able to use new functions that would cause incompatibilities if you fell back to a prior release.

Editor’s Note: This is the first in a series on reducing CPU resources or MIPS using DB2 10 for z/OS. This article will summarize Conversion Mode capabilities; the next installment will review DB2 10 New Function Mode.

New f unct ions are usually associated with new externals and application changes. Once those changes are made, the customer can often reduce CPU consumption. However, new functions sometimes require infrastructure changes. While circumstances vary depending on specific configurations, new infrastructures typically cause an average “CPU regression” of as much as 5 percent when the new functions aren’t exploited. This is illustrated in Figure 1 (page 43), where a negative CPU improvement indicates CPU regression. For example, the introduction in DB2 8 of 64-bit support and long-name support in the DB2 catalog resulted in greater average CPU regression (typically 5 to 10 percent). Catalog infrastructure change is one of the causes for CPU regression in DB2 8. The 64-bit structures in DB2 8 enabled much larger buffer pools

and enabled other structures to grow, yielding better I/O performance and CPU performance. DB2 9 made modest improvements in 64-bit exploitation, but DB2 10 is considered almost full exploitation; in DB2 10 very few data structures fall below the bar. To utilize the improvements, packages must be rebound to create the new 64-bit thread structures.

Large z/OS Page Frames
Among the infrastructure changes in DB2 10 is the way that PGFIX(YES) buffer pools are managed on a System z10* or zEnterprise* 196 (z196) processor. The System z10 processor with z/OS* 1.10 introduced 1 MB page frames. As the amount of memory increases, large page frames help z/OS improve CPU performance. IBM laboratory testing has measured CPU improvements of a few percent for specific transaction workloads. To exploit large frames, define the buffer

42

JA N UA RY/ FE B RUA RY 2 011

ibmsystemsmag.com/mainframe



IBM Systems Magazine, Mainframe Edition - January/February 2011

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe Edition - January/February 2011

IBM Systems Magazine, Mainframe Edition - January/February 2011
Table of Contents
On the Web
Editor's Desk: Time is Expensive
Data Display: Utilities, Users and Devices Are Getting Energy Wise Are Getting Energy Wise
Think Smarter: Smart Storage Solutions Let You Have It All
Insider: Energy Efficiency is More Than an Optimized Server
Trends: Case Study Shows IBM’s zEnterprise System Reduces Costs Across the Business
Moving Forward: UniGroup Inc. develops a mainframe-based Web tool to create a more flexible business model.
Tipping the Scale: Labor expenses should influence IT acquisition decisions.
Four-Star Advantage: The Polaris Workshop maps out a custom platform strategy.
Tips and Techniques: Reduce Resource Consumption on DB2 10 for z/OS
Solutions
Advertisers' Index
Stop Run: System/360 Pioneer Fred Brooks Teaches Design That Still Shapes Computing
IBM Systems Magazine, Mainframe Edition - January/February 2011 - IBM Systems Magazine, Mainframe Edition - January/February 2011
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Cover2
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 1
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 2
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 3
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Table of Contents
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 5
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 6
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 7
IBM Systems Magazine, Mainframe Edition - January/February 2011 - On the Web
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 9
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 10
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 11
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Editor's Desk: Time is Expensive
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 13
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Data Display: Utilities, Users and Devices Are Getting Energy Wise Are Getting Energy Wise
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 15
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Think Smarter: Smart Storage Solutions Let You Have It All
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 17
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 18
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 19
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Insider: Energy Efficiency is More Than an Optimized Server
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 21
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 22
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 23
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Trends: Case Study Shows IBM’s zEnterprise System Reduces Costs Across the Business
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 25
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 26
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 27
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Moving Forward: UniGroup Inc. develops a mainframe-based Web tool to create a more flexible business model.
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 29
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 30
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 31
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Tipping the Scale: Labor expenses should influence IT acquisition decisions.
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 33
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 34
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 35
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Four-Star Advantage: The Polaris Workshop maps out a custom platform strategy.
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 37
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 38
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 39
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 40
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 41
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Tips and Techniques: Reduce Resource Consumption on DB2 10 for z/OS
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 43
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 44
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Solutions
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Advertisers' Index
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Stop Run: System/360 Pioneer Fred Brooks Teaches Design That Still Shapes Computing
IBM Systems Magazine, Mainframe Edition - January/February 2011 - 48
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Cover3
IBM Systems Magazine, Mainframe Edition - January/February 2011 - Cover4
IBM Systems Magazine, Mainframe Edition - January/February 2011 - RF1
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com