Memory for MIPS: Leveraging Big Memory to Boost DB2 for z/OS CPU Efficiency

Project and Program: Information Management, Database

Tags: Proceedings, 2016, SHARE in San Antonio 2016

System z server memory is getting bigger all the time (a z13 can be configured with 10 TB of the stuff); and it's more common to find z/OS LPARs with 100 GB or more of real storage; however; at many DB2 for z/OS sites mainframe memory is an under-utilized resource; in that it's not leveraged for maximum performance benefit.
In this session you'll get information on how to use real storage to reduce DB2-related CPU consumption by 1) getting your buffer pool house in order (i.e.; getting the most out of your buffer pool configuration without making it larger); 2) being bold -- but not reckless -- in asking for more memory for DB2 buffer pools to reduce I/O activity; and 3) using storage for threads; dynamic SQL; RID processing; and sorting in a CPU-savvy way.-Robert F. Catterall-IBM Corporation

Back to Proceedings File Library