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.
Table 1. Db2 Administration Foundation 1.1.0.6 (UI81666) new and changed functions
Feature Description APAR
IBM® Db2 Analytics Accelerator for z/OS® You can now perform new actions on the Db2 Analytics Accelerator and its queries:
  • Manage software updates for a Db2 accelerator. To perform this action from the Overview tab, click the overflow menu on the System information tile and select Manage software. The following options are available:
    • Transfer software version
    • Apply software version
    • Remove software version
    • View software installation progress
  • Manage encryption for a Db2 accelerator. To perform this action, on the Overview tab, click Accelerator actions, and select Manage encryption.
  • See the textual representation of a query in the Db2 accelerator. To perform this action, on the Queries tab of the Db2 accelerator, click the overflow menu for a query and select Visual explain details.
  • See the updated health and performance of the Db2 accelerator. To see the finished tasks, click the Monitor tab and then click Finished tasks.
 PH47974
Table 2. Db2 Administration Foundation 1.1.0.5 (UI80701) new and changed functions
Feature Description APAR
IBM Db2 Analytics Accelerator for z/OS You can now perform several new actions on the Db2 Analytics Accelerator and its queries:
  • Configure and save the trace for a Db2 accelerator. To perform these actions, on the Overview tab, click Accelerator actions, and then click Manage trace.
  • Start or stop replication for a Db2 accelerator. To perform this action, on the Overview tab, click Accelerator actions, and then select Replication events.
  • Start or stop members of the Db2 accelerators that are part of a data sharing group. To perform this action, on the Overview tab, click Manage Members on the Key information tile.
  • Cancel a query in the Db2 accelerator. To perform this action, on the Queries tab of the Db2 accelerator, select the query that you want to cancel, click the overflow menu of the selected query, and then select Cancel.
  • See the graphical representation of a query in the Db2 accelerator. To perform this action, on the Queries tab of the Db2 accelerator, select the query, click its overflow menu, and then select Visual explain.
  • See the diagnostic data of a query in the Db2 accelerator. To perform this action, on the Queries tab of the Db2 accelerator, select the query, click its overflow menu, and then select Capture query environment.
  • See the health and performance of the Db2 accelerator. To see the system utilization, data slices, current tasks, and other related information, open the Monitor tab.
 PH45035
Db2 for z/OS support Support has been added for Db2 for z/OS, 13.1 (5698-DB2)V13 subsystem in UMS. You can now register a V13 subsystem on UMS.
Table 3. Db2 Administration Foundation 1.1.0.4 (UI79781) new and changed functions
Feature Description APAR
IBM Db2 Analytics Accelerator for z/OS

You can now explore Db2 accelerators by using IBM Db2 Analytics Accelerator for z/OS. Before using Db2 accelerators, you must configure UMS to use these services by completing the steps mentioned in the Configuring UMS for Db2 Analytics Accelerator topic.

The tables and queries in the accelerator are listed on separate tabs on the accelerator's detail page. You can perform various tasks for the tables and queries by using the overflow menu.

 PH44706
SQL explorer enhancements You can now upload an input file as a filter for capturing SQL queries.
Stabilized SQL is added as a new source while exploring SQL queries.
Table 4. Db2 Administration Foundation 1.1 PTF 3 (UI78606) new and changed functions
Feature Description APAR
Object management You can now view the object details of the members of a data sharing group (DSG). For information about how to explore DSG members and view their details, see Exploring objects. PH42479
Case sensitive search is now supported while searching objects.
You can now run the SQL query of a package by clicking Run on the SQL tab on the Object details page.
The Access tab for objects, such as tablespace and table is now called Status.
Explore SQL You can search the SQL queries that are available for various profiles and sources by using the Explore SQL page. You can use this page to complete the following tasks:
  • List the SQL statements that are available in different plans and packages.
  • Stabilize and free the SQL statement that are available for the Statement cache source.
  • Run or tune the listed SQL statements.

For information about how to use this feature, see Exploring SQL.
Subsystem management The value of dbaSqlid is set as per the value you provided while registering the Db2 subsystem.
SQL Tuning Multiple rows are added if you click the Capture query environment button multiple times.
The job ID does not change if you switch between Statistical advisor and Visual explain tuning actions.
You can now use the SQL Tuning page to also capture the SQL query environment.
You can now switch between multiple tuning jobs.
Table 5. Db2 Administration Foundation 1.1 PTF 2 (UI77754) new and changed functions
Feature Description APAR
SQL tuning You can now tune SQL queries by using IBM SQL Tuning Services.

To tune an SQL query, use either the SQL processor or the Tune button that is available on the SQL tab of the Object details page of a package.

Before using IBM SQL Tuning Services, you must configure UMS to use these services.

 PH41007
Object management You can now save a search filter for the new Alias object type.
All column filter now maintains selected values after applying filter on another column.
The Select all option for column selector is now enabled at all times.
The Clear all button now clears all applied filters.
The Overview tab now lists the updated information after bind statement changes.
You can now edit and run the DDL statement of an object by launching the SQL processor from the DDL tab.
You can view full SQL statement and tune each entry in the SQL tab for package object details.
You can now increase the graphql API timeout limit.
The Overview tab under object details now lists information on unregistered subsystems for registered DSG members.
Column filters now support name, object type, and schema while exploring objects.
You can now update an existing search filter while exploring objects.
You can now press an Enter key to apply your search criteria while exploring objects.
Table 6. Db2 Administration Foundation 1.1 PTF 1 (UI76534) new and changed functions
Feature Description APAR
Object management The Default value column under the Data tab now lists the selected default values. PH39068
Clicking the Register button from the function, packages, and stored procedure object view now navigates you to the subsystem registration page.
You can now copy the report content from the View report pop-up.
Clicking on a table name under the Relationship tab will now navigate to the Overview tab.
Clicking the subsystem name on the object hierarchy of the referential integrity now navigates to the subsystem overview page.
You can now stay on the same view after a successful bind or rebind operation.
The Bind tab now lists the correct package name for the data sharing group.
SQL processor The SQL processor now lists correct results when column names are similar.