This topic summarizes the recent enhancements and changes in Db2 Automation Expert.
11-24-2025
Table 1. 11-24-2025
updates
| Description |
Related APARs |
| The utility estimation feature now provides estimation results in a panel for online builds.
For batch builds, the generated estimates are listed in the ESTIMATE DD. Messages and the following
topics were added or updated:
|
UO05653 (PH68402, PH68852) |
| The table in the topic Db2 13 function level support was updated
for Db2 function level 507 support. |
See the table in the topic. |
09-12-2025
Table 2. 09-12-25 updates
| Description |
Related APARs |
| When you are installing and configuring the software required for utility estimation, note
that the version of NumPy that is automatically installed with the scikit-learn package is
incompatible with the pandas package that is required for utility estimation. To install the correct
version of NumPy, install NumPy v1.23.4 before installing scikit-learn. The topic Installing the required Python packages was updated. |
PH67968 |
| The REORG INDEX utility is now supported as part of the optional utility estimation feature.
The topic Estimating utility execution times and messages DAJB760I and DAJB768I were
updated. |
UO03769 (PH65777) |
| The Group PI Partitions in Step field was added to the Reorg
Utility Profile Options panel to allow all parts of a partitioned object that do not have
a defined non-partitioning index to be grouped together in the same step. The topic Setting REORG options was updated. |
UO03551 (PH60347) |
| Db2 Automation Expert utility profile panels that contained the single field
Max Tape Vols/DASD Units have been changed to separate the field into for
volume counts and DASD counts. When values are specified in these fields, they apply to the SYSREC,
SYSUT1 and SORTOUT DDs, and any in-line COPY DDs. Information about the fields was added to the help
panels for the REORG TABLESPACE, REORG INDEX, CHECK, COPYTOCOPY, MERGECOPY and COPY utility
profiles. The utility profile topics Selecting the copy type, COPYTOCOPY options, MERGECOPY options, Setting REORG options, and Setting index REORG options were updated with
new screens. |
UO04602 (PH65750, PH60022, PH67444) |
05-30-2025
Table 3. 05-30-2025 updates
| Description |
Related APARs |
| The machine learning model file format for the optional utility estimation feature has
changed. If you installed the machine learning model from an earlier PTF, you must replace the
existing models with the models provided in this APAR, and retrain the new models using the
instructions in the topic Training the models. In addition,
a new Python library must be installed; for more information, see the topic Installing the required Python packages. |
UO03310 (PH66536) |
| You can now enter REF or R as an abbreviation for the REFRESH command that is available on
some maintenance window panels. |
UO03079 (PH63302) |
| Instructions for configuring the ad-hoc utility API were updated in Installing and configuring the ad-hoc utility API for Db2 Automation Expert. |
None |
04-30-2025
Table 4. 04-30-2025 updates
| Description |
Related APARs |
| The table in the topic Db2 13 function level support was updated
for Db2 function level 507 toleration and
support. |
See the table in the topic. |
11-08-2024
Table 7. 11-08-2024 updates
| Description |
Related APARs |
| The table in the topic Db2 13 function level support was updated
for Db2 function level 506 toleration and
support. |
See the table in the topic. |
08-28-2024
Table 8. 08-28-2024 updates
| Description |
Related APARs |
| 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. |
UI98172 (PH62600) |
| Support was added for the FROMLASTFLASHCOPY keyword in the COPYTOCOPY utility. The topic
COPYTOCOPY options and message DAJ322E were
updated. |
UI98172 (PH62600) |
| The Utility History panel that is accessed from the Db2 Automation Expert main menu is
only valid for Db2 13 function level 501 and later subsystems. Message DAJ835E was modified. |
UI98172 (PH62600) |
| MAXPRIME or PCTPRIME values are ignored when primary and secondary allocation values are
specified in a template. New build message DAJB551I was added. |
UI98172 (PH62600) |
07-25-2024
Table 9. 07-25-2024 updates
| Description |
Related APARs |
| The new Db2 Utility Compare feature generates a before-and-after
comparison of utility execution data for Db2 objects in Db2 Automation Expert profiles. Execution data is gathered from the Db2
utilities history and object-level history tables, and includes CPU times, zIIP times, SORT times,
and elapsed times. The topics Analyzing utility execution with Db2 Utility Compare, Configuring and running the Db2 Utility Compare JCL, and Db2 Utility Compare summary report and
messages were added for this enhancement. The topic Verify that your environment meets software requirements was updated. |
UI97609 (PH61837) |
| 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 an object profile, Updating a utility profile, Updating an exception profile, and Updating a job profile were modified.
|
None |
| The table in the topic Db2 13 function level support was updated
for Db2 function level 505 toleration and
support. |
See the table in the topic. |