Db2 for z/OS and its ecosystem

 View Only

Enhancements to the Db2 for z/OS modernization tools

By MADHAVI AMIRNENI posted 4 hours ago

  
By Madhavi Amirneni and Eric Radzinski

The Db2 for z/OS tools modernization portfolio is comprised of a set of related products that makes it easier for application developers and database administrators of all skill levels to work with Db2 for z/OS. Two of these products, IBM SQL Tuning Services and IBM Db2 for z/OS Developer Extension, were updated recently with some useful enhancements.



IBM SQL Tuning Services

The latest updates to SQL Tuning Services were made available on June 26th in the form of APAR PH60806. The major enhancement in this APAR is the addition of a new API, single_query_tuning_actions, which provides several new capabilities:

  • The ability to invoke multiple tuning actions for a single query simultaneously. Prior to the availability of the single_query_tuning_actions API, you needed to invoke multiple APIs, one for each tuning action that you wanted to run. Now, you can specify a comma-separated list of all the tuning actions that you want to run and invoke them in a single operation. Currently, this new API supports a subset of tuning features that does not include the workload-level APIs.
  • The ability to invoke tuning actions without creating or specifying a tuning profile. This eliminates the potential maintenance that is required when the password that’s associated with a tuning profile expires or is changed.
  • The ability to implement multi-factor authentication for SQL tuning actions.
This APAR also delivers multiple fixes and minor enhancements, which you can read about in What’s new in SQL Tuning Services.



IBM Db2 for z/OS Developer Extension

Db2 Developer Extension 2.1.6 was released on Visual Studio Code Marketplace on June 28th and provides the following new features and improvements:

  • The ability to easily import your existing Db2 database connections from IBM Data Studio. This new feature helps to simplify the transition from Data Studio to Db2 Developer Extension.
  • Integration of the tuning capabilities that are provided by the new SQL Tuning Services single_query_tuning_actions API:
    • Running multiple tuning actions simultaneously
    • Tuning SQL without a tuning profile
    • Tuning with multi-factor authentication
  • The ability to debug external SQL stored procedures.
  • Comprehensive support for filtering columns for all Db2 database objects.
  • Support for specifying multiple filtering criteria on the same column.
  • Added support for selecting multiple Java dependencies simultaneously when deploying Java stored procedures.
  • Added support to display full text for LOB/CLOB data types.
  • Improved performance of viewing catalog navigation objects.

A comprehensive list of enhancements and fixes is available in our change log, and you can find information about how to use these new features in our What's new in this release.

We encourage you to take some time to explore how you can use these new features and fixes in your Db2 for z/OS environment.
0 comments
12 views

Permalink