DB2 12 for z/OS


DB2 12 is the latest version of DB2 for z/OS and is built on the proven availability, security and scalability of the IBM system Z platform. The latest enhancements give organisations the tools and capabilities they need to meet the demands of mobile workloads and increased mission-critical data. DB2 12 for z/OS delivers world-class analytics and online transaction processing (OLTP) performance.

Key Benefits & Improvements

  • DB2 12 promises CPU reductions of up to 10% for OLTP workloads, and is up to 100 times faster for more complex queries
  • Improved business insight – highlight concurrent queries run up to 100x faster
  • Faster mobile support – 6 million transactions per minute via RESTful API
  • Enterprise scalability, reliability and availability for IoT apps – 11.7 million inserts per second, 256 trillion rows per table
  • DB2 12 Utilities and Tools – Unlocking the power of DB2 12 and more offering comprehensive solutions helping organisations save time and money
  • QMF 12 delivers support across data sources and platforms from VSM, IMS and DB2 to REST APIs and Spark support
  • Enhanced in-memory capabilities to improve price/performance and exploit the latest System z hardware capabilities

Technical pre-requisites

  • z/OS V2.1 Base Services, (5650-ZOS) or later
  • z196, or higher, processors running z/OS V2.1 or later
  • DB2 11, running in New Function Mode

DB2 z/OS Version Migration Services

DB2 12 for z/OS Training and Education

  • 1 Hour Management Overview
  • Technical Overview - half day
  • Version 10 to 12 Migration Workshop - 3 days

DB2 12 for z/OS Implementation Services

  • Migration Cost/Benefit Analysis
  • Migration Planning Workshop
  • Implementation Support
  • Post Implementation Support