What’s new in this release

Db2 for z/OS Developer Extension 2.1 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
• Indexes¹
• Packages¹
• Plans¹
• 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.

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.