| Support for version file comparisons in CM batch |
PH72561 |
2026-08 |
| Option for Object Comparison summary reports to include only changed objects |
PH72244
PH72245 (GOC) |
2026-07 |
| Ability to retrieve trace data for accelerators in the background |
PH72103 |
2026-07 |
| TRANSFER OWNERSHIP support for procedures, functions, and sequences |
PH71601
PH71602
|
2026-06 |
| LASTUSED column added to the interpretation panel for plans |
PH71578 |
2026-06 |
| Support for CURRENT LOCK TIMEOUT and DEADLOCK_RESOLUTION_PRIORITY |
PH71305 |
2026-05 |
| Drop impact report improvements |
PH71113 |
2026-05 |
| Enhanced DISPLAY DDF output |
PH71323 |
2026-05 |
| Support for I/O counts in real time statistics |
PH71125
PH71126
|
2026-05 |
| Support for STMT_HASHID2 |
PH71125
PH71126
|
2026-05 |
| Support for the SHRLEVEL column in SYSUTILITIES |
PH71125
PH71126
|
2026-05 |
| Details displayed for Db2ZAI status |
PH71125
PH71126
|
2026-05 |
| Generic ignores for ownership and compression |
PH70998
PH70999 (GOC)
|
2026-04 |
| Health reports |
PH70895
PH70896
PH71041
|
2026-04 |
| Support for modifying indexes when changing a primary key or unique constraint |
PH70650 |
2026-04 |
| Flexibility when specifying the SQL PA CLIST library |
PH70204 |
2026-03 |
| Enhanced REBIND control and reporting in Object Comparison Tool |
PH70332
PH70373 (GOC)
|
2026-03 |
| Ability to mass delete changes in Change Management |
PH70330 |
2026-03 |
| Support for IBM Integrated Synchronization replication in IDAA 7.5 |
PH69369 |
2026-01 |
| Object Compare report can include original names of dropped objects |
PH69237
PH69308
|
2025-12 |
| Support for more local application control with Db2 profile tables |
PH69230 |
2025-12 |
| Drop impact reports list dependent objects that prevent the drop |
PH69072 |
2025-11 |
| Ability to control whether pending changes are applied when using the DDL line command |
PH69074 |
2025-11 |
| Removing duplicate COPY and RUNSTATS operations in CM batch jobs |
PH69081 |
2025-11 |
| Redirected recovery from an image copy |
PH69075 |
2015-11 |
| Support for specifying table space usage in the work file database |
PH68642
PH68643
|
2025-11 |
| Support for SYSTIME_PERIOD_ADJUST in a profile |
PH68642
PH68643
|
2025-11 |
| Support for MONITOR product_type CONNECTIONS FOR SECURITY for a profile with AUTHID |
PH68642
PH68643
|
2025-11 |
| Support for MONITOR product_type CONNECTIONS FOR SECURITY for a profile that uses RACF-generated token (IDT) for authentication |
PH68642
PH68643
|
2025-11 |
| Support for profile attribute WARNING_DIAGLEVEL0 |
PH68642
PH68643
|
2025-11 |
| Improvements to catalog copy jobs |
PH68642
PH68643
|
2025-11 |
| Trusted context support for local and remote connections |
PH68642
PH68643
|
2025-11 |
| Support for new value for CDDS_MODE subsystem parameter |
PH68642
PH68643
|
2025-11 |
| Support for UTIL_MODIFY_REC_DELETEDS subsystem parameter |
PH68642
PH68643
|
2025-11 |
| EXPLAIN(ONLY) support for Db2 REST services |
PH68119 |
2025-09 |
| EXPLAIN on dynamic SQL |
PH67814 |
2025-09 |
| Interface to Db2 Query Monitor |
PH67906 |
2025-09 |
| Custom SSID qualifiers when searching RACF profiles |
PH67907 |
2025-09 |
| Interface to Db2 Log Analysis Tool |
PH67678 |
2025-08 |
| Support for MODIFY STATISTICS PART |
PH67750 |
2025-08 |
| Db2 13 FL507: Support for online conversion of table partitioning from PBR to PBG |
PH67403
PH67457
PH67853
|
2025-07 |
| Updates to the Sequence Objects (ADB21Q) panel |
PH65789 |
2025-07 |
| Support for REORG SCOPE PENDING |
PH66759
PH66857 (GOC)
|
2025-06 |
| Support for EXPLAIN PACKAGE |
PH66866 |
2025-06 |
| Db2 13 FL507: Support for primary and secondary space allocations greater than 64 GB |
PH66531 |
2025-05 |
| Support for buffer pool pseudo-close interval and refresh enhancement |
PH66508 |
2025-05 |
| Improvements to the ALT line command |
PH66398 |
2025-05 |
| Support for EXPLAIN(ONLY) for advanced trigger packages |
PH65970 |
2025-04 |
| Support for abbreviated spelling APPLCOMPAT |
PH65951 |
2025-04 |
| Support for specifying IP subnet addresses for trusted contexts |
PH65971 |
2025-04 |
| New warning about tables with DATA CAPTURE CHANGES during comparisons |
PH65602 |
2025-03 |
| Support for automatically removing dropped tables from an accelerator |
PH65331 |
2025-02 |
| Improvements to managing REST services |
PH65354 |
2025-02 |
| Improved RACF support |
PH65355 |
2025-02 |
| Improvements to cleaning up obsolete packages |
PH65038 |
2025-02 |
| RACF support |
PH64720 |
2025-01 |
| Ability to view JAR information |
PH64720 |
2025-01 |
| Ability to manage buffer pool authorizations |
PH64720 |
2025-01 |
| Support for BY ALL in REVOKE statements and revoke impact reports |
PH63381 |
2025-01 |
| Support for running TRUNCATE to delete all table rows |
PH64740 |
2025-01 |
| Support for IBM Db2 Analytics Accelerator for z/OS 7.5 |
PH64721 |
2025-01 |
| Db2 13 FL506: Support for non-disruptive clearing of data partitions with LOAD |
PH63985
PH63986
|
2024-11 |
| Support for loading partitions |
PH63985
PH63986
|
2024-11 |
| Db2 13 FL506: Support for adding implicitly hidden ROWID columns |
PH63985
PH63986
|
2024-11 |
| Db2 13 FL506: Support for multi-row INSERT |
PH63985
PH63986
|
2024-11 |
| Ability to specify utility templates and other CM batch options for multi-target changes |
PH63146 |
2024-11 |
| Simplified option selection in Db2 Object Comparison Tool |
PH63721
PH63722 (GOC)
|
2024-10 |
| Simplified way to run utilities on all table spaces or indexes in a database |
PH63545 |
2024-10 |
| Support for viewing and managing accelerated packages |
PH63372 |
2024-09 |
| Enhancements to the CAT command |
PH62040
PH62041
|
2024-09 |
| Ability to generate DDL for hidden ROWID columns |
PH63073
PH63074 (GOC)
|
2024-09 |
| TCz option to separate GRANT statements |
PH62395 |
2024-08 |
| Ability to ignore column order when comparing tables |
PH62527
PH62528 (GOC)
|
2024-08 |
| Ability to alter implicit table spaces by using ALT |
PH61198 |
2024-08 |
| Ability to view RUNSTATS profile text |
PH62129 |
2024-07 |
| Support for new REORG and CHECK DATA utility options |
PH62122
PH62123 (GOC)
|
2024-07 |
| Support for redirected recovery of indexes |
PH61707 |
2024-06 |
| GEN option to preserve the physical partition order |
PH61704 |
2024-06 |
| Db2 13 FL505: Support for temporal versioning for security-related Db2 catalog tables |
PH61291
PH61292
|
2024-05 |
| Db2 13 FL505: Support for ZAI trace destination |
PH61154 |
2024-05 |
| Support for STATIME_DDF zparm |
PH61154 |
2024-05 |
| SQL Data Insights support |
PH61157 |
2024-05 |
| Ability to view and alter DSSIZE for indexes and index partitions |
PH60436 |
2024-05 |
| Improved consistency in CM batch utility parameter values |
PH61155 |
2024-05 |
| Utility history enhancements |
PH60926 |
2024-04 |
| Non-disruptive ADD COLUMN NOT NULL with no default |
PH60828 |
2024-04 |
| Ability to specify the ADBTEP2 MAXE value in CM batch |
PH60855
PH60856 (GOC)
|
2024-04 |
| Additional column information available when altering tables |
PH60528 |
2024-04 |
| Support for EXPLAIN table enhancements |
PH60390
PH60391
|
2024-04 |
| Support for new IDAA trace data options |
PH60534 |
2024-04 |
| Support for CREATE TABLE LIKE statements when comparing DDL |
PH60527 |
2024-04 |
| Support for more granular filtering in MONITOR CONNECTIONS FOR SECURITY profiles |
PH60529 |
2024-04 |
| Support for new REPAIR utility options |
PH60526 |
2024-04 |
| Improved error detection for CREATE TABLE and ALTER TABLE statements |
PH59776 |
2024-03 |
| Automatic rebinds when running ADBTEP2 jobs |
PH59774
PH59775
|
2024-02 |
| Ability to pass parameters to user-defined primary commands |
PH59323
PH59324
|
2024-01 |
| New primary commands |
PH59323
PH59324
|
2024-01 |
| ALTER VIEW REGENERATE after altering columns |
PH55470
PH59334 (GOC)
|
2024-01 |
| Support for additional RUNSTATS INDEX options |
PH58315 |
2023-12 |
| Support for UNLOAD NOPAD when making catalog copies |
PH58226 |
2023-12 |
| REST service enhancements: creating a REST service in batch and deploying a REST service |
PH58019 |
2023-11 |
| Ability to save MIG specifications |
PH58133
PH58136
|
2023-11 |
| Ability to specify MAXPARTITIONS when moving tables from multi-table table spaces to UTS |
PH58158 |
2023-11 |
| Ability to manage APPLCOMPAT for expression-based indexes |
PH57692
PH57696 (GOC)
PH57698
|
2023-11 |
| Db2 13 FL504: Utility object-level history support |
PH57761
PH57762
|
2023-11 |
| Db2 13 FL504: Support for statement-level invalidation |
PH57761
PH57762
|
2023-11 |
| Db2 13 FL504: Support for trace enhancements |
PH57761
PH57762
|
2023-11 |
| Ability to run revoke impact reports in batch |
PH57694 |
2023-10 |
| Improved security for grant management |
PH57695 |
2023-10 |
| Support for MXAIDTCACH subsystem parameter |
PH57227 |
2023-10 |
| Ability to use a SELECT statement to specify source and target objects in a comparison |
PH57198
PH57326 (GOC)
|
2023-10 |
| New CM batch options to include foreign key changes when comparing objects |
PH55583 |
2023-10 |
| Object Compare report can include original names of added objects |
PH56749 |
2023-09 |
| Support for new LOAD options |
PH56994
PH56995 (GOC)
|
2023-09 |
| Grant management |
PH56285 |
2023-08 |
| LISTDEF lists in generated utility jobs |
PH55739
PH55751
|
2023-07 |
| Ability to manage APPLCOMPAT values for views |
PH37650
PH55431
|
2023-07 |
| Usability improvements for horizontally scrolling on table display panels |
PH37650
PH55431
|
2023-07 |
| New command to update the high-level qualifier for Db2 catalog data sets |
PH52946 |
2023-07 |
| Usability improvements for altering and renaming columns |
PH54154
PH54232
|
2023-06 |
| Support for large format data sets for utilities |
PH54657
PH54829 (GOC)
|
2023-06 |
| Improved usability for changing table space and index attributes at the object level |
PH54716 |
2023-06 |
| Support for new Db2 profile keywords |
PH54723 |
2023-06 |
| CM batch support for comparing DDL to DDL |
PH54480 |
2023-05 |
| Masking REST API |
PH53409 |
2023-05 |
| Masking support for removing a key label |
PH54152 |
2023-05 |
| Support for new Db2 subsystem parameters and values |
PH54153 |
2023-05 |
| Support for displaying index traverse counts and log reading tasks |
PH52342 |
2023-04 |
| Usability improvements for altering objects |
PH52343 |
2023-04 |
| Improvements when transporting work statement lists to other systems |
PH53235
PH53482 (GOC)
|
2023-03 |
| Support for FREE PACKAGE PLANMGMTSCOPE(PHASEOUT) |
PH51372 |
2023-03 |
| Support for additional values for the QUERY_ACCEL_OPTIONS subsystem parameter |
PH52919
|
2023-03 |
| Support for Db2 13 function level 503 |
PH52918
PH53061
|
2023-03 |
| Additional support for Db2 system profiles |
PH52346 |
2023-02 |
| Support for additional COPY utility options |
PH52344
PH52345 (GOC)
|
2023-02 |
| Interface to SQL PA |
PH50947 |
2023-02 |
| SQL formatter REST API |
PH51300 |
2023-02 |
|
Support for statement-level dependencies for packages
|
PH50890
PH51493
|
2022-12 |
|
Support for REORG LASTLOG
|
PH50651
PH50652 (GOC)
|
2022-11 |
|
Eliminate unnecessary changes when comparisons involve objects created prior to Db2 12
|
PH49601 |
2022-11 |
|
Ability to specify REBIND options when altering objects
|
PH50333 |
2022-11 |
|
Ability to estimate data set extents
Improvements to page set resizing
Usability improvements to space manager
Space estimator REST API
|
PH42549 |
2022-09 |
|
REORG SHRLEVEL default change to avoid pending changes
|
PH49639 |
2022-09 |
|
Improvements to inserting and adding partitions
|
PH48016 |
2022-08 |
|
AL support for online PBG to PBR conversion
|
PH47480 |
2022-08 |
|
Eliminate drop and create when altering table spaces
|
PH48508 |
2022-08 |
|
Ability to limit UNLOAD_ALTERED_TABLES to destructive alters
|
PH48010 |
2022-07 |
|
Simplified process for propagating multi-target changes to remote subsystems
|
PH47981 |
2022-07 |