What’s new in this release

2.2.0 (November 2024)

Db2 for z/OS Developer Extension 2.2.0 provides the following significant enhancements:

• Support for editing data in Db2 tables

• Support for deploying SQL user-defined functions

• Support for creating and deploying SQLJ stored procedures

• Support for debugging Java and SQLJ stored procedures

• Support for deploying multiple stored procedures at the same time

• Support for generating DDL

2.1.7 (July 2024)

Db2 for z/OS Developer Extension 2.1.7 provides miscellaneous fixes for importing database connections from IBM Data Studio and for tuning SQL.

2.1.6 (June 2024)

Db2 for z/OS Developer Extension 2.1.6 provides the following significant enhancements:

• Support for debugging native and external SQL stored procedures

• Support for tuning SQL statements without using a tuning profile

• Support for importing existing database connections from IBM Data Studio

• Complete support for filtering multiple columns

• Support for security mechanisms 7 and 9

• Compatibility with the Java 17 JRE

2.1.5 (March 2024)

Db2 for z/OS Developer Extension 2.1.5 provides the following significant enhancements:

Initial support for external stored procedures

You can now deploy and run external SQL stored procedures and external Java stored procedures. See the following articles to get started:

• Creating external SQL stored procedures
• Creating external Java stored procedures

Support for using a notebook interface

You can now edit and run SQL in a notebook interface. For more information, see Working with SQL in a notebook editor.

Support for multi-column filtering of database objects

You can now apply complex filtering criteria to a subset of Db2 for z/OS catalog objects, including:

• Databases
• Indexes
• Storage groups
• Stored procedures
• Tables

For more information, see Filtering by multiple columns.

Support for VS Code light mode theme

You can now customize the appearance of the Db2 Developer Extension interface by selecting from the available color themes. For more information, see Changing the color theme.

Support for 32-bit JRE

Starting with Db2 Developer Extension 2.1.5, a 64-bit JRE is no longer required. Note that although the requirement has been removed, using Db2 Developer Extension with a 32-bit JRE has not been tested extensively, so results might be unpredictable.

2.1.4 (December 2023)

Db2 for z/OS Developer Extension 2.1.4 provides the following significant enhancements:

An expanded set of SQL analysis and tuning features

By leveraging the functionality provided by Db2 Query Workload Tuner for z/OS 6.1, you can now run the following SQL analysis and tuning tools from within Db2 Developer Extension:

• Access Path Advisor
• Access Path Comparison
• Index Advisor
• Query Rewrite Advisor
• SQL Annotator

See Software requirements for using the SQL tuning features for information about the prerequisites for using SQL tuning features.

Support for exploring objects in Db2 for z/OS databases

You can now locate and explore the following Db2 for z/OS database objects from within Db2 Developer Extension:

• Databases
• Global variables³
• Indexes¹
• Packages¹
• Plans¹
• REST services³
• Schemas
• Sequences²
• Storage groups
• Stored procedures¹
• Tables
• Table spaces²
• Triggers²
• User-defined functions²
• User-defined types²
• Views¹

Note: The privileges that are required to navigate the catalog increased since the initial 2.1 release. See Navigating the Db2 catalog for the updated list of catalog tables that you need read access to.

You can now view and hide implicit objects by using the view icon ().²

¹ Delivered in Db2 for z/OS Developer Extension 2.1.1.
² Delivered in Db2 for z/OS Developer Extension 2.1.2.
³ Delivered in Db2 for z/OS Developer Extension 2.1.3.

Support for VS Code Remote Development

You can now take advantage of VS Code Remote Development support to create a remote Db2 Developer Extension development environment. See Support for VS Code Remote Development for more information.