The latest updates to the products that comprise the Db2 for z/OS modernization tools were released in November 2024. These tools are the replacement for Data Studio working with Db2 for z/OS Version 13 and its function levels. We encourage you to take a few minutes to read about these enhancements and how they can be applied in your Db2 for z/OS environment.
Db2 for z/OS Developer Extension 2.2.0
Stored procedure enhancements
In the area of stored procedures, a main focus of this release is on providing full support for Java and SQLJ. With Db2 Developer Extension 2.2.0, you can create, deploy, run, and debug external Java and SQLJ stored procedures, just as you’ve been able to do with native and external SQL stored procedures in previous releases of the extension.
In addition to Java and SQLJ support, this release of Db2 Developer Extension enables you to easily deploy multiple stored procedures, of any supported type or combination of types, in a single operation. This feature is useful when you need to process large data sets or configure multiple applications at once rather than handling them individually.
User-defined function enhancements
Another significant new feature is the ability to deploy SQL user-defined functions. A big efficiency benefit of using Db2 Developer Extension to deploy a UDF instead of manually executing SQL, is that you can save the various deployment options separately from the SQL itself, which means that you can easily push your code into a source code manager without having to remove your deployment options first.
Productivity enhancements
This release of Db2 Developer Extension includes the following significant enhancements that make it easier to work with your Db2 for z/OS data:
- You can directly edit data in Db2 for z/OS tables. This feature is an easier and more efficient alternative to writing and running DML to change table data.
- You can generate DDL for databases, tables, table spaces, indexes, and views, which makes it easy to re-create these types of database objects for archival purposes, for setting up a test system, or for creating templates to be used as models for new objects.
- The catalog navigation feature has been enhanced with support for filtering certain columns by blank values for databases, plans, packages, stored procedures, triggers, and user-defined functions. This enhancement gives you more flexibility when trying to locate the objects that you’re looking for.
Fixes and internal enhancements
Db2 Developer Extension 2.2.0 includes an extensive list of fixes and internal enhancements in the areas of security, connectivity, performance, and usability. For a complete list, see the latest updates to the
Change Log.
You can find more information about these enhancements in the Db2 for z/OS Developer Extension documentation repository.
Db2 Administration Foundation 1.2.1.1
Query tuning enhancements
In the area of SQL performance analysis and tuning, this latest release of Db2 Administration Foundation enables you to:
- Run SQL tuning actions against a single query without the use of a tuning profile. This enhancement reduces the complexity of the tuning process when you’re working with a specific SQL statement.
- Specify whether new access paths are created when you run tuning actions against a workload and choose to generate new Explain data for the workload. This enhancement provides you with the flexibility that you need when comparing the performance of existing access paths to recommended new access paths.
- Delete multiple tuning jobs in a single operation, which makes it easier to maintain your working environment.
- Gracefully cancel an in-process workload tuning job so that you don’t need to wait for it to finish before stopping it.
Db2 Analytics Accelerator enhancements
The graph that shows the tables accessed by query offers the following enhancements:
- The ability to filter table data by date or size range and to plot table space utilization against usage, which is useful for understanding and optimizing space utilization on the accelerator.
- The ability to export the table data to a CSV file.
Productivity enhancements
- A new Privileges tab enables you to view the privileges for database objects, remove implicit grants, and display only explicitly granted authorizations.
- The Data tab has been updated to enable you to edit values in a table cell, insert or delete a row in a table, and review your changes before committing them.
- A new Format SQL option makes it easy to format one or all of the SQL statement in the New statements tab to improve readability.
- Support has been added for customizing Java HTTP server code for working with larger file sizes.
SQL Tuning Services 2.1.0.7
The latest updates to IBM SQL Tuning Services include enhancements that support IBM Db2 Query Workload Tuner for z/OS features and to the SQL Tuning Services installation and configuration process. For a detailed list of these changes, see APAR PH63509.