New and changed functions
This topic summarizes the recent enhancements and changes in Db2 Automation Tool.
05-07-2026
| Description | Related APARs |
|---|---|
| Db2 Automation Tool registers itself with z/OS product registration when the ISPF interface starts and when a batch Db2 Automation Tool job is submitted. The topic Product registration was added. | UO07580 (PH70421) |
| The table in the topic Db2 13 function level support was updated for Db2 function level 508 toleration and support. | See the table in the topic. |
05-01-2025
| Description | Related APARs |
|---|---|
| A note was added the topic Group: MVS catalog exception conditions to clarify how MVS catalog exceptions are processed for PBGs. | None |
| The table in the topic Db2 13 function level support was updated for Db2 function levels 506 and 507 toleration and support. | See the table in the topic. |
08-07-2024
| Description | Related APARs |
|---|---|
| The table in the topic Db2 13 function level support was updated with APAR numbers for Db2 function level 505 support and toleration. | UI91406 (PH53760) and FEC common code PTF UI97047 (PH61116) |
| Support was added for the FROMLASTFLASHCOPY keyword in the COPYTOCOPY utility. The topic COPYTOCOPY options and message HAA322E were updated. | UI95493 (PH59463) |
| When a REORG is to be performed on a table space with a pending ALTER COLUMN SET command, the SYSPUNCH and SYSDISC DDs are automatically generated. Messages were added and updated. | UI97780 (PH52765) |
| If updates are made to any type of profile, you must rebuild any associated job profiles to ensure that the changes are made to generated jobs. The topics Updating object profiles by using the Update Object Profile Display, Updating a utility profile, Updating an exception profile, and Updating a job profile were modified. | None |
| The AT-TLS parameter setup example for smarter reorganization recommendations in Example of AT-TLS parameter setup was updated. | None |
03-05-2024
| Description | Related APARs |
|---|---|
| The table in the topic Db2 13 function level support was updated with APAR numbers for Db2 function level 504 support and toleration. | UI91406 (PH53760) |
| The STAT COLGROUP MEM SORT field on the Runstats Options panel had an erroneous value limit of 4096. This limit was removed. The topic RUNSTATS options was revised. | UI95686 (PH57772) |
| MAXPRIME or PCTPRIME values are ignored when primary and secondary allocation values are specified in a template. New build message HAAB551I was added. | UI94950 (PH56111) |
| The Utility History panel that is accessed from the Db2 Automation Tool main menu is only valid for Db2 13 function level 501 and later subsystems. Message HAA835E was modified. | UI94950 (PH56114) |
| Information was added to clarify how a symptom priority is calculated using a variance. The topic Modifying priorities for Db2 Automation Tool symptoms was updated. | UI57377 |
03-31-2023
| Description | Related APARs |
|---|---|
| The table in the topic Db2 13 function level support was updated with APAR numbers for Db2 function level 503 support and toleration. | UI83632 (PH50569) |
| Additional information about requirements for using the Db2 Automation Tool interface to the Db2 administrative task scheduler was added to Set up your environment prior to customization. | None |
01-23-2023
| Description | Related APARs |
|---|---|
| Support for Db2 function level 502 was added. The DEPLEVEL keyword was added to the REBIND utility and message HAAM567E was modified. | UI83632 (PH50569) |
11-09-2022
| Description | Related APARs |
|---|---|
| For table space and index REORGs, support for the LASTLOG keyword was added so that you can specify whether a REORG SHRLEVEL CHANGE utility applies any log records in the final log iteration of the LOG phase. The topics Setting SHRLEVEL CHANGE options AND Setting SHRLEVEL CHANGE options for index REORGs were updated and messages HAA839E and HAAB751W were added. | UI82492 (PH46991) |
| When creating a REORG utility profile that will be running a template image copy on a tape device, you can specify to turn off tape stacking if pending definition changes are detected when the job is built. The topic Setting REORG options was updated and messages HAA684E and HAAB750W were added. | UI80739 (PH44563) |
| For a MODIFY STATISTIC utility, you can include objects that are created with DEFINE NO. The topic MODIFY options was updated. | UI80739 (PH44563) |
| A new exception that allows you to exclude or include only partition-by-range table spaces was added. The topic Group: Select these conditions to limit the types of objects that are processed was updated. | UI82492 (PH46991) |
| For exception processing, when the REALTIMESTATS option is specified, an ACCESS command is issued for objects in the object profile that might cause conflicts with other running processes. You can skip the externalization of real-time statistics by specifying N in the new Execute RTS -ACCESS DATABASE field on the Shared Profile Parameters panel in Db2 Automation Tool setup (option 0 on the main menu). The topics Db2 Automation Tool setup options and Entering job generation defaults and other product parameters were updated and message HAAM457E was added. | UI82492 (PH46991) |
| You can override the severity of message HAAB605W during batch builds. The topic Building a job in batch was updated and messages HAAB730I and HAAM832E were added. | UI78176 (PH41976) |
| A new informational build message is issued when a RECOVER INDEX is specified, but the index was created with COPY NO attributes. Message HAAB720I was added. | UI82631 (PH49656) |
| The following new messages were added: HAA837E, HAAB607I, and HAAM950E. | UI80306 (PH47088), PH41382, UI78176 (PH41976) |
Changes for Db2 13 (06-03-2022)
| Description | Related APARs |
|---|---|
| The SYSIBM.SYSUTILITIES catalog table was added to Db2 13 to store runtime information on Db2 utilities. Db2 Automation Tool added a user interface so you can easily display and delete rows from this table. The topic Starting Db2 Automation Tool was updated, and the topics Viewing the utility history catalog table, Viewing and deleting utility history rows, and messages were added. | UI80596 |
| The topic Set up your environment prior to customization was updated for Db2 13 and the topic Db2 13 function level support was added to provide toleration and support PTF information for Db2 Automation Tool. | UI80596 |
| The Worksheets: Gathering parameter values for Db2 Automation Tool topic was updated with Db2 13 values on the DB2 Parameters panel in Tools Customizer. | UI80596 |
Changes for Db2 13 (05-19-2022)
| Description | Related APARs |
|---|---|
| Support was added for the new Db2 13 utility history catalog tables when recovering the catalog and directory. | UI80306 (PH44145) |
| Page sampling in inline statistics for the REORG TABLESPACE utility was added for Db2 13 and is supported on the Reorg Utility Statistics Options panel (when TABLE(ALL) is specified) and the Update Runstats Sample Specification window in an object profile when table-specific statistics are required. The topic Setting statistics options was updated. | UI80306 (PH44145) |
| Exception processing supports larger data types that were implemented in Db2 13 for many columns in the real-time statistics tables. | UI80306 (PH44145) |
| Db2 12 introduced the NOSYSUT1 keyword for REORG INDEX to improve elapsed time and CPU reduction for the utility. As of Db2 13, the NOSYSUT1 keyword is the default and only behavior allowed for REORG INDEX SHRLEVEL REFERENCE or CHANGE. In Db2 Automation Tool, when REORG INDEX SHRLEVEL REFERENCE or CHANGE is specified in a utility profile on a Db2 13 subsystem, the NOSYSUT1 keyword is not available on the Reorg Index Utility Profile Options panel, nor is the keyword generated, as it is the default utility behavior. The topic Setting index REORG options was updated and message HAAB731I was added. | UI80306 (PH44145), UI78708 (PH42437) |
| Exception processing can detect the pending status that ALTER PARTITIONING TO PARTITION BY RANGE induces, and can trigger a REORG to apply the pending changes (or trigger another appropriate action). | N/A |
| The WRITELOG option of the REPAIR utility is for specialized use and is supported only in the Db2 REPAIR utility. If this keyword is desired, consult the REPAIR utility information in the IBM Db2 for z/OS documentation. | N/A |
Additional changes (05-19-2022)
| Description | Related APARs |
|---|---|
| The topic Loading and unloading profiles in batch was updated. | UI80372 (PH43205) |
Support was added for the following Db2 12 keywords:
|
UI78708 (PH42437) |
| Support for the PCTPRIME keyword was added when allocating data sets for utilities when using templates. The topic Updating data set options was updated. | UI78783 (PH41536), UI80732 (PH44226) |
| Restrictions were added to the Tools Customizer Automation Tool customization package name and Catalog history package list field descriptions regarding package names. The topic Worksheets: Gathering parameter values for Db2 Automation Tool was updated. | N/A |
| Db2 Utilities Enhancement Tool is no longer available. References to the tool were removed from the documentation. Topics Db2 Automation Tool V4.3 - features and benefits and Setting SHRLEVEL CHANGE options were updated. | N/A |
12-15-2021
| Description | Related APARs |
|---|---|
| Support was added for MERGECOPY in utility profiles. The topics Creating utility profiles, MERGECOPY options, and Specifying copy options and data set names for MERGECOPY were added or updated, and message HAA093W was added. | UI72002 |
| In exception profiles, the SYSTABLEPART column REORG_LR_TS is now used to determine whether a REORG or LOAD REPLACE has ever been done on an object. The topic Groups: Real-time statistics was updated. | PH35233 |
| Support was added to the CHECK DATA utility profile to allow you to control the package compatibility level behavior for dynamic SQL with the SET CURRENT APPLICATION COMPATIBILITY statement. The topic Specifying CHECK DATA exception tables was updated and messages were added. | PH33241 |
| Support was added to the RUNSTATS utility profile for the keyword STATCLGMEMSRT. The topic RUNSTATS options was updated. | UI70780 |
| How advanced SQL and selection criteria are applied to select table spaces and indexes in object profiles was clarified. The topics Adding table spaces from a list with advanced SQL, Using advanced SQL with the Wildcard field to add table spaces at job build time, Adding indexes from a list with advanced SQL, Using advanced SQL with the Wildcard field to add indexes at job build time, and message HAAM809E were updated. | None |
10-18-2021
| Description | Related APARs |
|---|---|
| Information was added about multi-factor authentication (MFA) support. The topic Set up your environment prior to customization was updated. | None |
The following Db2 12 keywords were added to utility profiles and the UNLOAD utility:
In addition, messages were added to support these keywords. |
PH33241 |
The Modify options panel was enhanced to:
|
PH33241 |
| Support was added to allow you to automatically include a table space's related history and archive tables at job run time. The topic Processing history and archive tables was added and messages were added for this enhancement. | UI72002, UI76108 |
| When deleting a maintenance window, you now have the option to delete all actions assigned to the maintenance window. The topic Deleting a maintenance window and message HAAM448E were updated. | UI73304 |
| Support for the NOCHECKPEND keyword was added to the REORG TABLESPACE utility profile. The topic Setting REORG options was updated. | PH38719 |
| The &SELECT9 variable description in the skeleton topic HAAREORJ was updated. | PH35737 |
| The topic Db2 12 function level support was updated to add PTFs for Db2 function levels 508, 509, and 510. | UI65918 |