By Katherine Soohoo and Eric Radzinski
Db2 for z/OS Developer Extension 2.1, which was released on February 24th, provides Db2 for z/OS SQL application developers with some powerful new performance and ease-of-use capabilities.
Integration of new SQL analysis and tuning tools
Db2 Developer Extension 2.1 was developed in conjunction with a new release of Db2 Query Workload Tuner for z/OS that provides Db2 Developer Extension users with a host of new SQL analysis and tuning tools.
Prior to this latest release of Db2 Developer Extension 2.1, the available SQL analysis and tuning features were limited to Capture Query Environment, Statistics Advisor, and Visual Explain. Now, with the capabilities provided by Db2 Query Workload Tuner 6.1, you have access to the following additional SQL performance tools directly from the Db2 Developer Extension interface:
Access Path Advisor
Access Path Comparison
Query Rewrite Advisor
By enabling the extended set of SQL analysis and tuning features, you have a comprehensive set of tools for ensuring that your SQL runs as efficiently as possible. For example, as shown in the following graphic, you can now generate access path recommendations and index recommendations to improve a single query’s performance:
For more information about how Db2 Query Workload Tuner for z/OS 6.1 is integrated into Db2 Developer Extension, see Software requirements for using the SQL tuning features.
In addition to the new set of SQL analysis and tuning features, the Db2 Developer Extension 2.1 interface has been significantly enhanced with the addition of robust Db2 catalog navigation capabilities. You can now easily search for, filter, and locate the storage groups, databases, tables, and schemas, that are associated with the SQL code that you write:
Remote development support
Lastly, for those who prefer to or have a requirement to use remote development environments, Db2 Developer Extension 2.1 includes support for creating a remote Db2 Developer Extension development environment. See Support for VS Code Remote Development for more information.
We hope you’ll take some time to explore and start using these new capabilities soon. As always, the latest version of the Db2 for z/OS Developer Extension is available free of charge from the Microsoft Visual Studio Code Marketplace.