This paper provides a high-level overview of the functions, features, and improvements that were introduced in IBM DB2® 12 for z/OS®. These businesses gain a competitive advantage, improve business efficiency and effectiveness, and discover business insights from their existing data.

The paper is intended for DB2 system administrators, database administrators, and application programmers, but might also be of interest to IT managers and executives. A more detailed description of DB2 12 is available in IBM DB2 12 for z/OS Technical Overview, SG24-8383.

The purpose of this paper is to provide the reader with an understanding of some of the key changes that were introduced in DB2 12 for z/OS, including the following topics:

• Performance for traditional workloads
• Performance enablers for modern applications
• Application Enablement
• Reliability, availability, and scalability
• Security

Migration and prerequisites

Introduction

Performance for traditional workload: In-Memory Computing

Access path/access plan stability

Performance enablers for modern applications

Application enablement

Reliability, avilability, and scalability

Upgrade and prerequisites