What's new in Db2 SQL Performance Analyzer

This topic summarizes the technical changes for this edition.

This section describes recent technical changes to SQL Performance Analyzer.

January, 2024

  • Support for DSN8EXP and DSNAEXP in Db2 SQL Performance Analyzer has been removed as these functions are removed from Db2 for z/OS. Use the EXPLAIN privilege instead. For more informaton about EXPLAIN privilege, see the 'Explicit system privileges' section in the IBM Db2 for z/OS documentation.

  • A new Summary output report is added. This report contains one line for each SQL statement to meet the filter requirement.

  • A new field named 'Select the report type to display' is added to the COMPARE and TEST panels. Using this field, you can display the delta report or the summary report in the ISPF mode. Enter D for delta report or S for summary report.
  • The return of reason code format is updated from decimal to hexadecimal during CAF connection.

December, 2023

  • Support for Db2 13 function level 504 has been added.

October, 2023

  • Now you can view the last set of What If report using the LWIR command without re-running the What If commands (W or WIF) on the ANLPLIM1 panel.
  • The Tools Customizer usability is updated for better way of handling parameters.

June, 2023

  • Earlier when SQL Performance Analyzer was invoked from ANLCSPA edit macro, the What-if command was disabled. With the new enhancement you can use the What-if command to create different scenarios with the optimizer to try to influence access path selection.
  • Now you can customize a JCL, submit it and specify a library to save it without exiting from SQL Performance Analyzer.

April, 2023

A new pop-up panel, EXPLOPT (Advanced Explain and Bind options) for TEST function has been added, where you can specify the Bind options APREUSE and APREUSESOURCE. See Options for TEST for more information.

March, 2023

A new section Db2 13 function level support has been added. This section provides information about the tolerated or supported function levels by Db2 SQL Performance Analyzer.

December, 2022

  • We have provided integration support for SQL Performance Analyzer and DB2 Administration Tool integration. You must install APAR- PH50947 for Db2 Administration tool.

  • A new section named Manage Virtual Index has been added for details about viewing, deleting, and updating the virtual indexes.

October, 2022

  • The ADMIN_EXPLAIN_MAINT stored procedure executes the TCz job ANLDCRab (template ANLDCRE8) for creating the Db2 EXPLAIN tables.

May, 2022

  • Support for Db2 version 13 was delivered via APAR PH45320.
  • Note, in addition, APAR PH42701 must be installed for Tools Customizer for z/OS support of Db2 13.

March, 2022

  • A new pop-up panel, EXPLOPT, allows you to specify the current temporal SYSTEM_TIME and BUSINESS_TIME for dynamic Explain. See EXPLAIN options for details.
  • A new column, Expansion Reason, has been added to the Db2 SQL Performance Analyzer Reports Menu. See Db2 SQL Performance Analyzer reports menu for details.
  • Support for Temporal Tables has been added for functions 1.1-1.6 of SQL Performance Analyzer.

October, 2021

  • A new field, *Plan name for the DSNTIAD utility, was added in the customization menu in DB2 Utilities – common
  • New fields were added in the customization menu: In section SQL PA DB2 Objects, such as *Owner(SET CURRENT SQLID), Schema for ANL objects, Utility for creating DB2 objects
  • In the new section SQLPA BIND, plans, packages options were created.
  • DDLs for creation of all Db2 objects, Bind, grant were directly added in customization jobs.
  • You can specify a custom high-level qualifier (HLQ) for these SQLPA customized libraries: SANLDATA, SANLCSV, SANLCLST, SANLJCL, SANLLODS and SANLPARM. If you do not specify a custom HLQ, it defaults to the high-level qualifier of the SQLPA installation.

September, 2019

  • New examples have been added to show how customers have typically set parameter values in the ANLCNTL and ANLPARM members. See ANLCNTL configuration parameters and ANLPARM user parameters for more information on the examples.
  • New fields on COMPARE and TEST panels. Package Cost Filter limits processing to a specified difference in total cost of all statements within a package. Statement Cost Filter limits processing to a specified difference in total cost of each statement within a package. Show Invalid Packages determines whether a warning message will be shown for packages flagged as invalid.