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: 92

Add a Comment

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

Join The World of DB2

Events

Latest Activity

A blog post by Surekha Parekh was featured

Hot off the Press! Installing and Configuring IBM Db2 AI for z/OS Version 1.4 An IBM Redpaper publication

Check out this new "Complimentary" Db2 AI for z/OS Version 1.4 Red paper Installation and ConfigurationLearn MoreAbstractArtificial intelligence (AI) enables computers and machines to mimic the perception, learning, problem-solving, and decision-making capabilities of the human mind. AI development is made possible by the availability of large amounts of data and the corresponding development and wide availability of computer systems that can process all that data faster and more accurately than humans can.What happens if you infuse AI with a world-class database management system, such as IBM Db2®? IBM® has done just that with Db2 AI for z/OS (Db2ZAI).Db2ZAI is built to infuse AI and data science to assist businesses in the use of AI to develop applications more easily. With Db2ZAI, the…See More
21 hours ago
Jim Reed updated an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 22, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Jul 21
Carol Davis-Mann posted a blog post

Management Overview: DB2 Continuous Delivery Function Level Upgrades

By Julian StuhlerBackgroundWith the advent of DB2 12 for z/OS, IBM has moved to a more agile approach for delivering new function to DB2 customers, known as “continuous delivery”. Major new releases of DB2 will now happen more rarely, with smaller packets of new functionality being delivered via the routine product maintenance process. This allows IBM to develop and release new features much more frequently, thereby reducing “time to value” – a familiar DevOps message.To allow DB2 customers to absorb this new function in a flexible and efficient way, IBM has also delivered a comprehensive set of capabilities that allow the “function level” of the overall DB2 system to be easily progressed while insulating individual applications from the impact of any changes via the “application compatibility level” set for each program.Read Julian Stuhler's article…See More
Jul 14
Jim Reed posted an event
Thumbnail

Build simple to multifaceted dashboards in QMF for Workstation at Online

July 20, 2021 from 8am to 9am
Today businesses need real time visual dashboards and reports across all their data, including hard to reach data across IBM Z non-relational data sources. QMF for Workstation makes visualizing virtually any data a reality, including IMS, VSAM, Adabas, IDMS and DB2 for z/OS data sources.This session will showcase and demo QMF’s dashboard/application building interface in QMF for Workstation from simple to multifaceted.See More
Jul 14
A video by Surekha Parekh was featured

Db2 AI for z/OS Version 1.4

IBM Db2 AI for z/OS version 1.4 is a powerhouse of enhancements! Db2 AI for z/OS infuses more AI into your Db2 environment, making it operate smarter and mor...
Jul 5
A blog post by Daniel Luksetich was featured

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
Daniel Luksetich posted a blog post

Db2 for z/OS and JSON

I wrote a very short story about using the JSON/SQL support in Db2 for z/OS. I also wrote an introduction to JSON support in Db2 for z/OS article for IDUG.The story and link to the IDUG article is here:https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/This is a direct link to the IDUG article, but you need an IDUG login account (which is free).https://www.db2expert.com/db2expert/introduction-to-db2-for-z-os-json-sql-support/See More
Jun 30
William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
Jun 23
A blog post by Surekha Parekh was featured

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!

Live Db2 12 Client Panel 30th June 2021 - Sign Up today!HURRY SIGN UP TIME IS HURRYING OUTSummaryDb2 for z/OS is the strategic enterprise database that has evolved and adapted to meet client needs for over 35 years. John Campbell IBM Distinguished Engineer has been one of key developers from IBM Silicon Valley Lab that has been extremely influential in driving some of the innovation around the core strengths and business value of Db2 for z/OS.We are bringing together some of our Db2 for z/OS clients so that they can share some of their "use cases" and experiences around Db2 12 upgrade journey and discuss how they are exploiting, planning to exploit the new technology to leverage  their Db2 for z/OS data to…See More
Jun 22
Daniel Luksetich posted a blog post

Traditional Db2 Development and Modern Database Development

This article is the first of a four-part series addressing Db2 for z/OS and modern development utilizing a Agile methodology and DevOps processes. In this article we define traditional versus modern development and how Db2 for z/OS, while remaining the premier database for high volume system of record applications, might be left behind when it comes to best practices involving innovation. Did you notice that “Db2” follows “Traditional” in the title of this article, but “Database” follows “Modern”? It is my opinion that Db2 for z/OS is not the first database that comes to mind when considering a DevOps development methodology. However, there is no reason why it shouldn’t be!The first thing we need to do is to identify what we mean by traditional versus modern development. In this series of articles, we will be speaking specifically of the waterfall methodology versus an Agile methodology and DevOps practices.To read the entire article please follow this link:…See More
Jun 21
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Jun 21
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 21

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

Forum

ADM10501W - Health indicator "Database Automatic Storage Utilization"

Started by ONLO in Application Development and DB2 Jun 16. 0 Replies

AIX Version 6.1DB2 10.5.6Hi every body,I got the above error:MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization" ("db.auto_storage_util") breached the "upper" warning threshold of "80 %" with value "88 %" on "database"…Continue

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

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service