Memory for MIPS: Leveraging Big Memory to Boost DB2 for z/OS CPU Efficiency
Project and Program:
Information Management,
Database
Tags:
Proceedings ,
SHARE Atlanta 2016 ,
2016
System z server memory is getting bigger all the time (a zEC12 can be configured with 3 TB and z13 up to 12.5TB of system memory), 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, packages, RID processing, and sorting in a CPU-savvy way.-Troy Coleman-IBM
Back to Proceedings File Library