Db2 12 for z/OS and Db2 Tools for z/OS announcing a streamlined way to help accelerate adoption of all new features, function levels (FL), FL support and more

What is being announced?

IBM Db2 12 for z/OS (Db2 12) and select IBM Db2 Tools for z/OS (Db2 Tools) offerings have recently been refreshed, allowing IBM to provide much more current SMP/E base installable product images. These images provide a streamlined method for clients creating new installations, or for Db2 clients planning to install and/or migrate to Db2 12.These point-in-time product images drastically reduce the time required to be up and running to take advantage of new features and functions.   


New features delivered at regular intervals via Continuous Delivery for Db2 12 and Db2 Tools have focused on enhancing support for mission-critical transactional processing on IBM Z while also extending into analytics and artificial intelligence (AI) as clients develop their hybrid cloud strategies.  Read the full announcement letter for all the details.

What are some of the features and value that are included in the refresh?

Db2 12 delivers greater analytic and hybrid cloud capabilities and extended support for mobile and AI development while optimizing resources for changing, diverse, and growing workloads. In Db2 12, IBM introduced continuous innovation through continuous delivery via function levels. These are designed to release new Db2 features to market more rapidly and to respond to changing market and competitive conditions faster, all with less risk and effort. Function level 500 – 508 inclusive can be enabled according to your schedule.   

Db2 Tools for z/OS provide the required Db2 12 function level support to meet your business needs on your timeline. Db2 Tools deliver on a continuous release schedule, committed to Db2 for z/OS support, delivering timely value for critical Db2 applications and systems.You can take advantage of the features in the Db2 functions levels with the support provided by Db2 Tools.  For example:

  • Db2 function level 508 provides the capability to move data from multi-table simple or multi-table segmented (non-universal [non-UTS]) table spaces, which have long been deprecated, to Universal Table Space (UTS) to improve quality, stability, function, and availability. UTS permit the consolidation of data and table to Db2’s strategic table space type. This feature enables clients to automate the conversion of thousands of existing deprecated tables to the modern UTS format, where they can take advantage of availability features that help improve application and database operations and performance without an outage. The Db2 Administration Tool for z/OS helps with a faster, easier, and safer conversion to Universal Table Space Format. It easily identifies table spaces requiring migration, generates a job to create the new UTS table spaces, and automatically runs all actions required to move the data and rebind packages as needed.
  • Db2 function level 505 provides a new REBIND phase-in capability for application packages, which enables database administrators to issue REBIND PACKAGE commands successfully when target packages are being concurrently executed. Db2 Object Comparison Tool issues the REBINDs for packages invalidated during a change for fewer REBIND failures as a result of timeouts and less manual intervention. Db2 Administration Tool supports COPYID column for packages. SQL Performance Analyzer for z/OS finds candidate packages that can benefit from REBINDs. Db2 Query Monitor and OMEGAMON XE for Db2 PE can perform CPU and elapsed-time comparisons before and after the REBINDs to verify the improvements

For more details about Db2 Tools and Db2 12 function level support, see the Db2 12 function level compatibility tables.

In addition, Db2 12 has delivered more than 450 enhancements based on client requests (RFEs and Ideas), with more than 1900 collective votes cast, including the following:

  • Next-generation application support that enables modern applications to access and consume Db2 for z/OS data. This feature promotes rapid, agile development of new and existing applications, enabling you to reuse existing assets and further your Db2 return on investment. New Db2 commands have been delivered for greater control and support for versioning of REST services. This gives you more flexibility to create and deploy new application requirements without affecting existing applications. Another update supports the promotion of services from a development to production environment. This is designed to enable you to copy existing REST services more easily, which can save time and resources.

Significant Db2 Tools enhancements have also been added through continuous delivery that improve operational efficiency, optimize actionable insights and automation, and provide greater business readiness and protection, including the following:

  • Db2 Administration Tool for z/OS
    • Adds API support that enables clients to take advantage of their investment in Db2 and Db2 Tools. This can enable clients to easily include existing capabilities in their Db2 applications, which can speed time to market for Db2 applications by reducing time in development, testing, and maintenance.
    • Provides new capability to detect timeout conditions and automate restarts, which can reduce manual interventions to make changes more reliably to Db2 applications.
    • Provides enhanced recovery support with the capability to automatically retry failed timeouts by specifying the number of retries and the amount of time between retries. This feature enables you to better implement Db2 object changes on your time schedule, removing wait time, manual restart, and optimizing resources.           
  • Db2 Automation Tool for z/OS provides advanced SQL for index selection, giving users more control over index criteria to invoke intelligent automated actions. This feature provides a simplified way to target automated maintenance to only the indexes that require it.
  • Db2 Log Analysis Tool for z/OS provides automated table versioning support. With a growing and complex Db2 environment, the Db2 log files increase in size. Table versioning and dropped columns alter a table's mapping based on a point in time can cause a mismatch, requiring manual intervention, affecting availability. Db2 Log Analysis Tool detects these object changes and enables automated table versioning to improve availability and productivity.

Who benefits from this announcement?

To simplify the adoption of these enhancements, new Db2 clients, or Db2 11 clients who have not completed their migration to Db2 12 in all environments can benefit.  The Db2 for z/OS SMP/E contains more than 1800 PTFs, including all function-level activation PTFs, up to and including function level 508. The Db2 for z/OS installation verification testing has validated a greatly simplified product installation, largely due to the reduced number of PTFs to apply and the reduced number of applicable HOLD actions to evaluate.  Additionally, the new install of the product image using z/OSMF dialogs has streamlined and automated the process of running the multiple jobs required to successfully install and configure Db2.

New Db2 Tools customers, existing IBM Db2 Tools clients who are not on most recent release of product or have purchased additional Db2 Tools(s) or a client who is participating in a Db2 Tool Proof of Concept (PoC)  can benefit from the integration of more than 1630 PTFs collectively.  Installation verification and regression testing has been performed on all these updated Db2 Tools images. Additionally, the Db2 Tools product images included in the announcement use z/OSMF dialogs to reduce installation time and effort.

Both Db2 for z/OS and the Db2 Tools included in this announcement are available in Shop zSeries by using the order information in the Reference Section of the announcement.


Views: 68

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Latest Activity

Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
5 hours ago
An event by Surekha Parekh was featured

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
5 hours ago
Carol Davis-Mann posted a blog post
Carrie Tutino posted events
Annette Zawacki added a discussion to the group Data, Analytics and AI on IBM Z
Jun 2
Michael Hardie posted an event

Scottish Db2 User Group - June 22nd 2021 at Virtual via GoToMeeting

June 22, 2021 from 9am to 4:30pm
Jun 1
An event by Surekha Parekh was featured

What’s new in Db2 AI for z/OS and Watson Machine Learning for z/OS at Virtual LIVE

June 1, 2021 from 11am to 12:15pm
May 27
Annette Zawacki posted an event
May 27
Roger Smith liked Jane Man's blog post Convert JSON data to Relational Format
May 21
Peter E Saxe posted a discussion
May 20
Jim Reed liked Annette Zawacki's discussion Is your Db2 for z/OS data part of your AI strategy? Learn how you can build AI models anywhere and deploy on IBM Z
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Surekha Parekh's event Achieving Optimal Availability, Usability and Performance with Universal Table Space - Part 2
May 12
Profile Icon via Twitter
Join the live launch webcast, "What’s New in Db2 AI for z/OS and Watson Machine Learning for z/OS" June 1 at 11 AM… https://t.co/yvz9t7dwcC
TwitterMay 11 · Reply · Retweet
A blog post by Surekha Parekh was featured
May 11

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

who opened the scoring from the penalty spot

Started by long lin in What's hot ? Apr 22. 0 Replies

fotbollströja barn eget tryck Lionel Messi opened the scoring from the penalty spot, but that was as good as it got for Ronald Koeman's side as Mbappe took over to evoke memories of recent defeats to…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service