Utilizing Large Memory with DB2 12
Project and Program:
Information Management,
Database
Tags:
Proceedings,
2017,
SHARE San Jose 2017
DB2 12 for z/OS delivers significant performance improvement by exploiting larger system memory with z13. Not only supporting more efficient and larger buffer pools, DB2 12 provides in-memory indexes and numerous optimization utilizing memory. A fast index look up in memory is automatically created to speed up random key loop up. DB2 z/OS can insert 10 million rows per second utilizing in-memory look up to avoid space search in a new insert algorithm. Just as previous versions, the range of improvement varies depending on the workload characteristics. This session will help to set the right expectation for your workloads and what actions are needed or recommended to fully utilize DB2 12 improvement.-Akiko Hoshikawa-IBM Corporation
Back to Proceedings File Library