New-function APARs for Db2 Admin Tool 13.1

After GA, enhancements continue to be delivered later in the service stream, as part of new-function APARs.

The following table summarizes the APARs that introduce new function for Db2 Admin Tool 13.1. It does not include problem fixes or other maintenance APARs. Any APAR numbers that are followed by (GOC) are for Db2 Object Comparison Tool; all other APARs are for Db2 Admin Tool.

Description	APAR	Date
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 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