What's new in Db2 Administration Foundation

Db2® Administration Foundation has been updated to include new features, enhancements, and fixes.

To enable these features, you must install the latest Db2 Administration Foundation PTF and the compatible UMS PTF. To choose the appropriate compatible PTF, refer to the UMS PTF compatibility table.
Note: Some of the new and changed features require additional licenses and maintenance. For more information, refer to Requirements for additional capabilities.
Table 1. Db2 Administration Foundation 1.2.0.4 (UI94996) new and changed functions
Feature Description APAR
IBM® Db2 Query Workload Tuner for z/OS®
  • Capture SQL from a z/OS data set enables you to identify and display SQL statements that exist in a sequential data set or partitioned data set member and work with those statements by using other Db2 Administration Foundation features. For more information, see Capturing SQL from a z/OS data set. 
  • Workload-level support for Capture Query Environment enables you to capture information about the environments in which all the queries in a workload run. Before this update, the Capture Query Environment supported only single queries. For more information, see Capturing a query's environment.
 PH58303
Db2 Analytics Accelerator Loader for z/OS enhancements
  • You can now extract queries running on the Db2 Analytics Accelerator Loader as a CSV file.
  • To support smart table management, the following new columns are introduced on the Tables tab:
    • Last load time
    • Last statistics collection
    • Is timestamp collected
  • A Db2 applications table is added to the Monitor tab to enhance monitoring capability.
  • The following two columns are added to the Queries tab to enhance query monitoring:
    • Application stall time
    • Application handle
Table 2. Db2 Administration Foundation 1.2.0.3 (UI93734) new and changed functions
Feature Description APAR
IBM Db2 Query Workload Tuner for z/OS The following new features are available to licensed Db2 Query Workload Tuner users:
  • Index Impact Analysis

    Generates a report that shows the impact of applying the index changes that are recommended by Index Advisor and Workload Index Advisor. For more information, see Evaluating index recommendations before deploying them.

  • Workload Virtual Index Analyzer

    Enables you to test indexes to determine if the performance of the SQL statements that comprise a workload can be improved by creating indexes, dropping indexes, or both. For more information, see Analyzing the effects of applying index changes.

  • Workload Refine

    Enables you to modify an existing workload. For more information, see Refining SQL workloads.

  • Workload Explain Failure Reason

    Explains why SQL statements failed during a Workload Explain operation.

 PH56864
Support for DSN commands Command Execution API support is added to process the requested DSN Command.
IDAA Collect System Performance Data You can now request to change the default values given for collecting system performance data.
Table 3. Db2 Administration Foundation 1.2.0.2 new and changed functions
Feature Description APAR
IBM Db2 Query Workload Tuner for z/OS The following new features are available to licensed Db2 Query Workload Tuner users:
  • Workload Index Advisor

    Generates recommendations for creating, altering, or dropping indexes that can improve the performance of an SQL workload. This feature provides the DDL scripts that you can run and information about the existing indexes from the workload that you are tuning.

  • Workload Statistics Advisor

    Generates recommendations and RUNSTATS DDL for creating or modifying statistical views.

  • Workload Explain

    Workload Explain has been enhanced to support CURRENT QUERY ACCELERATION=ALL.

  • Workload Access Path Comparison
    Workload Access Path Comparison has been updated with the following enhancements:
    • You can now specify specific types of tuning jobs.
    • Internal jobs are no longer displayed during a Workload Access Path Comparison action.

    For more information, see Tuning SQL workloads.

  • Virtual Index Analyzer

    Virtually tests indexes to determine if the performance of a single query can be improved by creating indexes, dropping indexes or both. For more information, see Analyzing the effects of applying index changes.

 PH56033
Statistics tab for index and tablespace Implemented infrastructure changes to discover Db2 Administration Tool for z/OS from IBM Db2 Administration Foundation for z/OS. Db2 Administration Foundation is enabled with the Statistics tab for index and tablespace. For details, see Configuring Statistics tab. PH56033
Running Db2 command using templates You can view or edit the template of the Db2 command for one or more objects by using the Run Db2 command feature. For details, see Running Db2 commands using template.
Alert for OUT parameter SQL call statement now displays an error when only OUT parameter is available.
Table 4. Db2 Administration Foundation 1.2.0.1 new and changed functions
Feature Description APAR
IBM Db2 Query Workload Tuner for z/OS The following new features are available to licensed Db2 Query Workload Tuner users:
  • Workload Explain

    Gathers explain information for all statements in a workload and stores this information in the repository database. This information is used by other workload advisors to analyze these statements.

  • Workload Query Rewrite Advisor now provides a Results page.
  • The Results pages for Workload Access Path Advisor and Workload Access Path Comparison now enable you to display both high-level and low-level tuning results.
 PH54968
Tools Discovery Added the capability to find or discover the definition of external Db2 Tools that have been installed on the same z/OS system as the UMS instance. The definition of the tools is stored in YAML files located on UNIX System Services or within an MVS data set. For details, see the following links: PH54968
Loading tables to accelerators Implemented infrastructure changes to discover IBM Db2 Analytics Accelerator Loader for z/OS from IBM Db2 Administration Foundation for z/OS. Db2 Administration Foundation user interface changes can load tables to accelerators with Db2 Analytics Accelerator Loader. For details, see Configuring UMS for Db2 Analytics Accelerator Loader.
Parameters substitution Support for replacing SQL and call procedure parameters of the registered subsystems. For details, see Using SQL processor for Db2.
Cancel long-running search operation Support for canceling an ongoing search request in the ‘Explorer objects’ when the page takes a long time to load.
Storage tab for index and tablespace Implemented infrastructure changes to discover Db2 Administration Tool for z/OS from IBM Db2 Administration Foundation for z/OS. Db2 Administration Foundation is enabled with the Storage tab for index and tablespace. For details, see Configuring Storage tab.
Table 5. Db2 Administration Foundation 1.2.0.0 new and changed functions
Feature Description
IBM Db2 Analytics Accelerator for z/OS You can now perform new actions on the Db2 Analytics Accelerator and its queries:
  • Add a new Db2 accelerator. To perform this action from subsystem Overview tab, click Add new and provide new accelerator details.
  • To save space, you can archive tables on a Db2 accelerator. To perform this action from the Tables tab, select tables to archive and click the Archive option from the Archiving menu.
  • You can restore archived tables to a Db2 accelerator. To perform this action from the Tables tab, select tables to restore and click the Restore option from the Archiving menu.
  • Manage federated access for a Db2 accelerator. To perform this action from the Tables tab, select required tables and click the Federation menu. The following options are available:
    • Grant access

      You can grant access to tables in another subsystem. Upon completion of this action, you can create reference tables from those subsystems.

    • Remove references

      The remove reference option lets you delete references from an accelerator.

  • You can create a reference to a table in another subsystem. Upon completion of this action, the reference is created on the shared accelerator. To perform this action from the Tables tab, click the Create references button.
  • You can revoke access from a table that will prevent it from referencing a Db2 subsystem. To perform this action from the Tables tab, click the Revoke access button.