Db2 for z/OS and its ecosystem

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Announcing the latest updates to Db2 for z/OS Developer Extension

By Ariana Bibiano posted 29 days ago

  
We’re happy to announce that the latest release of Db2 for z/OS Developer Extension, 2.2.6, is now available on Microsoft VS Code Marketplace.

But before we tell you about all of the new features and enhancements in this release, we want to make you aware of a couple of changes to the prerequisite software for using Db2 Developer Extension 2.2.6:

  • Before you install or upgrade to version 2.2.6, you must have Java version 21 installed. If you are using a different Java version for existing projects, you can configure the Java version 21 path in the Db2 for z/OS Developer Extension settings.
  • Beginning with version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, the JCC license file has been updated to db2jcc_license_consvZS.jar. To use this new license file you will need to update it in the Db2 for z/OS Developer Extension settings.

Now, on to the new features and improvements in this release:

  • Support for editing SQL routines has been introduced as an ease-of-use enhancement that lets you do more from the catalog navigation view.
  • You can now load structured data from external delimited files into an existing table. This feature provides delimiter configuration, validation, progress tracking, and clear error reporting to ensure safe and predictable data loading.
  • You can now update multiple user IDs and passwords for multiple connection profiles at once.
  • You can now export Db2 for z/OS connections in another Visual Studio Code workspace or share them with other users. This feature enhances usability by allowing you to reuse existing connections settings to avoid manually re-entering the connection information.
  • Support for sorting data in an SQL results set for SELECT statements by enabling server-side sorting is an enhancement that makes it easy to sort your SQL results set without having to manually write an SQL statement with an ORDER BY clause. This feature is especially useful for sorting large results sets.
  • You can now set both NULL and non-NULL values to an array input variable for native SQL stored procedures.
  • Support for selecting a location in your file explorer to save SQL results or downloaded Capture Query Environment is an enhancement that improves usability by letting you select a location instead of manually typing out the path.
  • An enhancement to the query history view that displays the schema, and path if specified, for executed or deployed routines. This feature is especially useful when there are identical routine names across different schemas.
  • Improvements to the tuning actions panel provide the ability to select or deselect all of the tuning actions in the panel and support for preserving the tuning actions that were previously selected for a file.

You can find information about how to use these new features in What's new in this release. For the complete list of enhancements and fixes that are included in Db2 Developer Extension, see the May 2026 entries in the Change Log. Db2 Developer Extension 2.2.6 is available free of charge, from the Visual Studio Marketplace.
0 comments
31 views

Permalink

https://community.ibm.com/community/user/blogs/ariana-bibiano/2026/06/08/announcing-the-latest-updates-to-db2-for-zos-devel