What's new in Db2 Administration Foundation
Db2® Administration Foundation has been updated to include new features, enhancements, and fixes.
- New and changed functions of Db2 Administration Foundation 1.1.0.6 (UI81666)
- New and changed functions of Db2 Administration Foundation 1.1.0.5 (UI80701)
- New and changed functions of Db2 Administration Foundation 1.1.0.4 (UI79781)
- New and changed functions of Db2 Administration Foundation 1.1 PTF 3 (UI78606)
- New and changed functions of Db2 Administration Foundation 1.1 PTF 2 (UI77754)
- New and changed functions of Db2 Administration Foundation 1.1 PTF 1 (UI76534)
Feature | Description | APAR |
---|---|---|
IBM® Db2 Analytics Accelerator for z/OS® | You can now perform new actions on the Db2 Analytics
Accelerator and its
queries:
|
PH47974 |
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:
|
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. |
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. |
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:
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. |
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. |
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. |