Db2 12 for z/OS Database Design and Application Performance

Susan Lawson, YL&A Inc. - Tuesday 14 May - Session 2

With every new release of Db2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in Db2 12, that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features that can be utilized by DBAs and application programmers.


  • Database Design and Concurrency
    • Range-partition tablespace size increase
    • Partition insert into middle
    • Basic row format deprecated
    • LOB compression
    • Overflow for in-memory objects
    • In-memory indexes
    • Improved log sequence number
    • Claim and drain improvements
    • Improved lock avoidance checking
  • Data Availability
    • Option to skip PIT recovery for non-updated page sets
    • PIT recovery after materialization for UTS PBG
    • Pending column level alters
    • Pending level index compression
  • SQL and Optimization
    • Fast insert algorithm
  • DELETEs allowing interim commits
  • Static SQL resource limit
  • Reduced overhead on declared temps
  • Improved caching of generated values
  • Dynamic plan stability
  • Plan stability improvements
  • Profile support for stats feedback
  • Optional cache invalidation
  • Enhanced MERGE statement
  • SQL pagination syntax support
  • FREQVAL automated counts
  • UNION ALL and outer join improvements
  • Table UDF performance enhancements
  • Predicate evaluation improvements
  • Sort processing enhancements
  • Literal replacement BIND option

Platform: z/OS


← Back to all sessions

About: Susan Lawson


Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM GOLD Consultant for DB2 and z/Series, and an IBM Information Champion and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’ and the IBM ‘DB2 for z/OS V7 Application Programming Certification Guide’. She is also the co-author of several DB2 books including the IBM ‘DB2 10 for z/OS DBA Certification Guide’, IBM ‘DB2 9 for z/OS DBA Certification Guide’, ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’. She is also a SME(Subject Matter Expert) for the IBM Certification exams for DB2 z/OS Database and System Administration assisting with writing and verifying questions for the exams.