New-function APARs for Db2 Admin Tool 12.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 12.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
Support for STATIME_DDF zparm	PH61154	2024-05
Ability to specify the ADBTEP2 MAXE value in CM batch	PH60855 PH60856 (GOC)	2024-04
Support for new REPAIR utility options	PH60526	2024-04
Support for additional RUNSTATS INDEX options	PH58315	2023-12
Ability to specify MAXPARTITIONS when moving tables from multi-table table spaces to UTS	PH58158	2023-11
Ability to run revoke impact reports in batch	PH57694	2023-10
New CM batch options to include foreign key changes when comparing objects	PH55583	2023-10
Support for new LOAD options	PH56994 PH56995 (GOC)	2023-09
New command to update the high-level qualifier for Db2 catalog data sets	PH52946	2023-07
Improved usability for changing table space and index attributes at the object level	PH54716	2023-06
CM batch support for comparing DDL to DDL	PH54480	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
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 additional COPY utility options	PH52344 PH52345 (GOC)	2023-02
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 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
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
Ability to prevent binds when a CONTOKEN changes but the package version is the same	PH42301	2022-03
Support for additional Db2 12 subsystem parameters	PH42322	2021-12
ALT as an alternate line command for A	PH40458	2021-12
Support for new REORG INDEX utility options RECOVER support for auxiliary table spaces	PH37342	2021-12
Ability to specify an object scope when migrating objects	PH41894	2021-11
Support for renaming views	PH34099	2021-10
Support for new utility options Ability to specify a range of partitions when recovering objects	PH37341 PH40162 (GOC)	2021-10
Ability to restore packages after running the collection clean up function	PH35204 PH31960	2021-09
Support for new object attributes in Db2 12	PH31556	2021-09
Support for additional CREATE TABLE options for implicit table spaces	PH40076	2021-09
Support for additional Db2 12 subsystem parameters	PH40074	2021-09
Ability to control whether foreign keys are dropped during a comparison	PH39334 PH39653 (GOC)	2021-09
PAGESET_PAGENUM support	PH37926	2021-08
New command to display only explicitly granted privileges	PH39331	2021-08
Ability to view replication status and row count for accelerated tables	PH38103	2021-08
Usability improvements for preserving data when altering the NULLS attribute of a column	PH36418 PH38600 (GOC)	2021-07
Support for new utility options	PH35853	2021-06
Usability enhancements for Db2 12 function level 508 support	PH36790	2021-06
Support for specifying a compression algorithm at the object level	PH36485	2021-05
Support for high availability for accelerator-only tables	PH36482	2021-05
Support for tamper-proof audit policies	PH36481	2021-05
Expanded support for Db2 REST services	PH36687	2021-05
New stored procedure that returns the DDL for a single object	PH35130	2021-03
Expanded ability to view Revoke Impact reports	PH32457	2021-03
Improved specification status for source and target objects in comparisons	PH31168	2021-02
Ability to specify the detectChanges value when loading accelerated tables	PH29571	2021-02
Support for moving tables from multi-table table spaces to UTS	PH31554	2021-01
Support for Db2 REST services	PH31558	2021-01
Parent objects can be included when migrating tables or table spaces or generating SQL Extended schema support	PH30132	2021-01
Ability to insert a partition when altering a table space	PH27084	2021-01
Ability to choose an accelerator when launching Db2 Table Editor	PH31272	2020-12
Ability to register changes to column masks and row permissions	PH31186	2020-11
Additional commits for generated SQL statements that update catalog statistics	PH30515	2020-11
Improved consistency and usability for line commands	PH28560	2020-11
SET CURRENT APPLICATION COMPATIBILITY statements included in GEN and DDL output	PH28566	2020-11
Ability to refresh the CM change list by clicking a command	PH28892	2020-10
USS path names accepted when regenerating a DBRM	PH26043	2020-10
Support for Db2 12 function level 507 APPLCOMPAT value is displayed on the main menu	PH28647	2020-09
Panel scrolling support	PH28564	2020-08
CM batch parameter values are included in ADBMSGS	PH28563	2020-08
Support for Db2 12 fast index traversal Support for the new REGISTER option for UNLOAD and RUNSTATS	PH27090 PH28134 (GOC)	2020-08
Data preserved when altering the NULLS attribute of a column	PH24104 PH27716 (GOC)	2020-08
Ability to specify target function level when migrating objects	PH27083	2020-08
Support for Db2 12 recovery utility options	PH24002	2020-08
Support for long names in comparison summary reports	PH27085	2020-07
Ability to modify existing traces	PH27086	2020-07
Ability to save compare job options	PH27087 PH27130 (GOC)	2020-07
Support for Db2 12 function level 506	PH25686 PH27088	2020-07, 2020-10
Support for Db2 12 function level 505	PH24230	2020-06
Support for objects that you can no longer create in Db2 12 function level 504	PH22951 PH27083	2020-06, 2020-08
Use of ADMIN_INFO_SYSPARM instead of DSNWZP	PH22951	2020-06
Support for IBM Db2 AI for z/OS (Db2ZAI) Support for key labels New primary command to change the application compatibility level	PH22698	2020-05
Support for inserting partitions	PH20648	2020-04
CM batch option to generate JCL from a WSL	PH20257	2020-04
Ability to view a change that supersedes a change Exclusion of referential constraints when comparing objects with automatic target selection Conversion of ADB table spaces to UTS	PH22548	2020-03
Ability to view logical partition numbers and row counts for partitions	PH23202	2020-03
Improvements to CM recovery	PH21635	2020-03
Bind Manager functionality added	PH18439	2020-03
Plan names displayed on ADB21K	PH16874	2020-03
ADBTEP2 can automatically retry failed statements	PH20650	2020-02
New warning when the compare scope is insufficient Support for CONCENTRATESTMT and APREUSESOURCE bind options Support for new FREE PACKAGE options Ability to view package copy information	PH19997	2019-12
Support for INSERT ALGORITHM Support for LOAD BACKOUT Support for dynamic plan stability	PH16862	2019-10
Support for the UNLOAD privilege Support for REORG DROP_PART CM uses DSNUTILV instead of DSNUTILU Ability to specify how CM runs utilities Support for DELETE FETCH FIRST n ROWS ONLY Support for new SELECT clauses Reduced resource contention in CM Support for the COMPRESSRATIO column in SYSTABLESPACE APPLCOMPAT V12R1M505]	PH10086	2019-10
Support for updated IDAA trace details	PH09487	2019-07
Support for the INVALIDATECACHE and USE PROFILE statistics options Db2 Admin Tool dynamically finds the DECP settings	PH02457	2019-07
Improved function level messages Improvements to ADBMSGS	PH12055	2019-06
Support for Db2 12 continuous delivery APPLCOMPAT values for function levels	PH06164	2019-05
Invocation exit to set global variables	PH09606	2019-05
Readability improvements to ADBMSGS	PH08484	2019-05
CM can unload tables when analyzing changes	PH00552	2019-04
CM support for partition-level copies	PH03675	2019-02
Bind avoidance DBRM regeneration Collection clean-up	PH06267	2018-12
Ability to view object details in batch mode Ability to validate imported DDL in CM batch CM batch parameters for readable WSL	PI96053	2018-05
Ability to alter sequence aliases	PI92080	2018-03
Ability to define restart points in a WSL	PI61852	2018-03
Consolidation of messages into one file	PI66475	2018-03
Improvements to CM batch	PI74777	2018-03
UTILFROM ADDPART	PI80511	2018-03
New messages for CCSID changes	PI82330	2018-03