What’s new in this release

2.2.1 (April 2025)

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

Support for running and debugging user-defined functions (UDFs)
Support for deploying a combination of stored procedures and user-defined functions (UDFs) in a single operation
Support for controlling processing behavior if an error occurs when multiple routines are deployed simultaneously
Support for activating a new version of a native stored procedure or compiled UDF from catalog navigation
Support for calling a native or external SQL stored procedure from catalog navigation
Support for editing DISTINCT data types and enhancements to column headings when editing table data
Support for specifying additional collection IDs when tuning SQL through the use of the currentPackagePath property with a tuning profile and without a tuning profile
Documented a fix for truncated trailing zeros in the timestamp column of query results and table data

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:

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:

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.