2020 new-function APARs for Db2 Admin Tool 12.1
The following APARs were delivered in 2020. They introduced enhancements to Db2 Admin Tool 12.1 since the General Availability (GA) date.
Ability to choose an accelerator when launching Db2 Table Editor
PH31272 - December, 2020
When you edit a table by launching Db2 Table Editor from Db2 Admin Tool, you can now choose an accelerator from a list of accelerators that are associated with that table. The selected accelerator or accelerators are then used by Db2 Table Editor.
To enable this function, you must set the Pass accelerator name to Table Editor field to YES on the DB2 Parameters (CCQPDB2) panel when customizing Db2 Admin Tool.
Ability to register changes to column masks and row permissions
PH31186 - November, 2020
When using Change Management (CM), you can now register changes to column masks and row permissions. Previously, these changes were restricted in CM.
- CREATE and ALTER statements for masks and permissions
- ALTER TABLE ACTIVATE and DEACTIVATE ROW and COLUMN ACCESS
Additional commits for generated SQL statements that update catalog statistics
PH30515 - November, 2020
To reduce potential catalog lock contention, Db2 Admin Tool now adds COMMIT statements when generating more than 500 SQL statements that update catalog statistics. COMMIT statements are added as needed so that no more than 500 update statements are executed between commits. If necessary, COMMIT statements are added regardless of what you specify in the Commit statements per field on the Generate SQL from DB2 catalog (ADB2GENB) panel.
Improved consistency and usability for line commands
PH28560 - November, 2020
The ? line command is now valid on all table display panels. It displays all valid line commands for the current panel along with their descriptions.
Additionally, the process of defining your own line commands is simplified. All line commands are defined in one table, ADBLCMDS.
SET CURRENT APPLICATION COMPATIBILITY statements included in GEN and DDL output
PH28566 - November, 2020
When Db2 Admin Tool generates the DDL for a view, synonym, or hash-organized table, the generated output now includes any necessary SET CURRENT APPLICATION COMPATIBILITY statements. For example, to recreate synonyms or hash-organized tables when the current Db2 function level is 504 or higher, the application compatibility function level must first be set to 503 or lower. In this case, the following statement is added to the GEN or DDL output:
SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'You can generate the DDL for an object by using either the GEN or DDL line commands or the GEN primary command. Additionally, Db2 Admin Tool generates DDL to recreate objects as part of the running other functions, such as object comparisons.
Ability to refresh the CM change list by clicking a command
PH28892 - October, 2020
When using Change Management (CM), you can refresh the list of changes on the CM - Changes (ADB2C11) panel by clicking the new REFRESH command on the panel. Any status changes are displayed immediately. You no longer have to type the REFRESH (or REF) command to reload the data on the panel.
USS path names accepted when regenerating a DBRM
PH26043 - October, 2020
When using the Bind Manager function to regenerate a DBRM, you can now specify a z/OS UNIX System Services (USS) path name for the output. The package name is appended to the specified path name. Previously, you could specify only a partitioned data set (PDS). Now, you can specify either a PDS or USS path name on the Regenerate a DBRM Member (ADBPBMRD) panel. Additionally, on this panel, you can optionally specify a Db2 version and language for the DEFAULTS control statement.
Support for Db2 12 function level 507
PH28647 - September, 2020
Db2 12 FL 507 Db2 12 function level 507 introduces the new option CREATE OR REPLACE for external procedures and native SQL procedures. This new option provides an easy way for you to change your stored procedure definitions. Db2 Admin Tool supports this new option when performing operations on stored procedures. For example, you can specify that you want to use CREATE OR REPLACE when creating or modifying procedures. Also, Db2 Admin Tool can generate CREATE OR REPLACE PROCEDURE statements when comparing objects or when generating DDL for other functions.
The following panels have changes to support this new CREATE OR REPLACE option:
| Panel | Change |
|---|---|
| Generate SQL from DB2 catalog (ADB2GENB) panel | A new R option for CREATE PROCEDURE field |
| Create Procedure (ADB26CO) panel | A new Use CREATE OR REPLACE field |
Function level 507 also introduces specific names for procedures with the new SPECIFIC clause. In Db2 Admin Tool, you can use the existing STPNAME mask to mask the specific name for a native SQL procedure.
Panel scrolling support
PH28564 - August, 2020
The following panels are now scrollable to the right and left to display all columns of the associated Db2 catalog tables:
- Real-time Statistics for Table (ADBP1RTS) panel
- Information from SYSIBM.SYSCOPY (ADB21I) panel
- Stored Procedures (ADB21O) panel
- Application Plans (ADB21P) panel
- Sequence Objects (ADB21Q) panel
- Functions (ADB21F) panel
- Data Types (ADB21E) panel
- Triggers (ADB21J) panel
CM batch parameter values are included in ADBMSGS
PH28563 - August, 2020
The consolidated messages file, ADBMSGS, now lists values of CM batch parameters. ADBMSGS can include the following lists of values:
- The initial and profile values for the parameters
- The parameter values that were provided in an invocation override (by using the PARMS DD statement)
- The final parameter values that were used
Each of these lists is identified by message ADB7957I in ADBMSGS. Within each list, the parameters are ordered alphabetically. Parameters with blank values are not listed.
The first list (initial and profile values) is always included in ADBMSGS. The second two lists (invocation override values and final values) are optional. To control whether these last two optional lists are included, use the new CM batch parameter list_options. By default, these optional lists are not included in ADBMSGS.
Support for Db2 12 fast index traversal
PH27090 (Db2 Admin Tool), PH28134 (Object Comparison Tool) - August, 2020
You can use Db2 Admin Tool to manage fast index traversal, a new feature of Db2 12. Use the new 2I command on the System Administration (ADB2Z) panel to control which indexes use fast index traversal and display memory usage.
Support for the new REGISTER option for UNLOAD and RUNSTATS
PH27090 (Db2 Admin Tool), PH28134 (Object Comparison Tool) - August, 2020
When running the UNLOAD or RUNSTATS utilities in Db2 12, you can use the new REGISTER option in data sharing environments to specify whether pages that are read by the utility are registered with the coupling facility. In Db2 Admin Tool, you can specify the REGISTER value by using the new CM batch parameters util_runstats_shrlevel_change_register and util_unload_shrlevel_change_register or by specifying a value on one of the following panels:
- Specify Utility Options - RUNSTATS (ADB2USRA) panel
- Specify Utility Options - UNLOAD (ADB2USU) panel
Data preserved when altering the NULLS attribute of a column
PH24104 (Db2 Admin Tool), PH27716 (Object Comparison Tool) – August, 2020
When you alter whether a column can contain null values (the NULLS value in the SYSCOLUMNS catalog table), Db2 Admin Tool now drops and recreates the table by default. Db2 Admin Tool unloads the table, drops the table, recreates the table, and then loads the table. This behavior ensures that the column data is preserved.
You have the option to change this default behavior if you also specify that the altered tables are unloaded when the change is analyzed. (The Unload altered tables field on the Options for Change Functions (ADB2PCO) panel is set to YES.) In this case, you can change the value of the new field Recreate for NULLS change on the Options for Change Functions (ADB2PCO) panel to NO. (YES is the default value.) NO indicates that the column is to be altered by using ALTER TABLE statements instead of dropping and recreating the table. However, be aware that when changing the NULLS attribute of a column, specifying Recreate for NULLS change = NO might result in data loss. If the Unload altered tables field is set to NO, Db2 Admin Tool always drops and recreates the table when altering the NULLS attribute of a column.
This APAR also introduces a new corresponding Change Management (CM) batch parameter, recreate_for_nulls_change, to control this behavior.
Ability to specify target function level when migrating objects
PH27083 - August, 2020
You can now specify the function level for the target system when migrating objects. You can specify this value on the Generate SQL from DB2 catalog (ADBP8MG) panel in the new field Target Function Level. If the function level for the target system is not specified, the Migrate function uses the function level from the current APPLCOMPAT value on the source system.
Support for Db2 12 recovery utility options
PH24002 - August, 2020
You can use Db2 Admin Tool panels to specify utility options that are new in Db2 12 for the RECOVER utility and MODIFY RECOVERY utility.
Specifically, you can specify the following RECOVER options on the Specify Utility Options - RECOVER (ADB2USV) panel and the Specify Utility Options - RECOVER INDEX (ADB2UXV) panel:
- FLASHCOPY_PPRCP
- ALTERNATE_CP
- NOSYSCOPY
- SCOPE (which is part of the TORBA and TOLOGPOINT clauses)
You can also specify the following MODIFY RECOVERY options on the Specify Utility Options - MODIFY (ADB2USM) panel:
- DELETEDS
- NOCOPYPEND
- FLASHCOPY ONLY (which is part of the DELETE and RETAIN clauses)
Support for long names in comparison summary reports
PH27085 - July, 2020
The object comparison summary report is enhanced to display object names that are longer than 18 characters. These long names are displayed across multiple rows, in the same column and with the same indentation.
Ability to modify existing traces
PH27086 - July, 2020
In Db2 Admin Tool, you can now use panels to modify Db2 instrumentation traces. On the Display/Manage Traces (ADB2Z2T2) panel, when you issue the MT line command, a new panel is displayed, the Modify Trace (ADB2Z2TM) panel. On this panel, you can modify the trace classes, IFCIDs, and comment for the trace. Based on the selected options, Db2 Admin Tool generates the command for modifying the trace and executes it.
Ability to save compare job options
PH27087 (Db2 Admin Tool), PH27130 (Object Comparison Tool)- July, 2020
Previously, when you saved a dialog in Object Comparison Tool, the options on the Generate Compare Jobs (GOC5) panel were not included. With this APAR, all options on the Generate Compare Jobs (GOC5) panel and its subordinate panels (those panels that are displayed when you specify options such as UO and CO) can now be saved and restored.
Support for Db2 12 function level 506
PH25686 - July, 2020, PH27088 - October, 2020
Db2 12 FL 506 Starting with Db2 12 function level 506, you can use alternative built-in function names in Db2 Admin Tool. Additionally, Object Comparison Tool handles the implicit dropping of explicitly created universal and LOB table spaces as follows:
- Object Comparison Tool will not recreate a table space that was implicitly dropped when a table or LOB column was dropped and is not present in the source for the comparison.
- Object Comparison Tool will recreate an implicitly dropped table space if needed to drop and recreate an object.
Support for Db2 12 function level 505
PH24230 - June, 2020
Db2 12 FL 505 Db2 Admin Tool supports the following enhancements in Db2 12 function level 505:
- The ability to specify DECFLOAT columns in an index and as a key: In Db2 Admin Tool, you can specify a column of type
DECFLOAT as part of an index or primary key on the following panels:
- Redefine Index (ADB21XAR) panel
- Alter Index - Add Columns (ADB21XAA) panel
- Create Primary or Unique Key (ADBP7CTP) panel
- Create Primary or Unique Key (ADB26CTP) panel
- Rebind phase-in for packages: You can view the new CopyID value in Db2 Admin Tool on the following panels:
- The Package Dependencies (ADB21KD) panel, which is now scrollable so that you can view all columns in the SYSPACKDEP catalog table.
- Interpretation of an Object in SYSPACKDEP (ADB21KI) panel
Support for objects that you can no longer create in Db2 12 function level 504
PH22951 - June 2020, PH27083 - August, 2020
Db2 12 FL 504 Starting with Db2 12 function level 504, Db2 does not allow you to create synonyms, segmented or partitioned (non-UTS) table spaces, or hash-organized tables. APAR PH22951 ensures that Db2 Admin Tool can still process these deprecated objects. Therefore, if you have activated function level 504 and have existing objects of one of these deprecated types, you can still use Db2 Admin Tool to do functions such as migrate these objects to another subsystem, generate the SQL for these objects, and use copies of the Db2 catalog.
- For the CM batch interface, this ability is controlled by the new adbtep2_retry_deprecated_obj parameter.
- For the online interface, this ability is controlled by the Retry Deprecated Obj field on the Batch Job Utility Parameters (ADB2UPA) panel.
An operation might result in an SQLCODE -20008 if the current application compatibility level is function level 504 or higher and a deprecated object has to be created. The new ADBTEP2 parameters handle this situation.
Use of ADMIN_INFO_SYSPARM instead of DSNWZP
PH22951 - June, 2020
Db2 Admin Tool now calls the ADMIN_INFO_SYSPARM stored procedure, instead of the DSNWZP stored procedure, to get Db2 subsystem parameter values. DSNWZP is deprecated in Db2 12. You must ensure that ADMIN_INFO_SYSPARM is operational.
Support for IBM Db2 AI for z/OS (Db2ZAI)
PH22698 - May, 2020
Db2 12 FL 503 Db2 12 function level 503 introduced support for Db2ZAI, which leverages machine learning technology to improve the Db2 optimizer. You can start, stop, and manage Db2ZAI from Db2 Admin Tool.
Support for key labels
PH22698 - May, 2020
Db2 12 FL 502 Db2 12 function level 502 introduces key label management to support z/OS DFSMS transparent data set encryption. If you have function level 502 activated, you can use Db2 Admin Tool to manage key labels and perform operations on objects with key labels. For example, you can:
- Create a new table or storage group with a key label.
- Add or change a key label on an existing table or storage group.
- Generate DDL for objects with key labels.
- View key label information in the Db2 catalog.
- Compare objects with key labels.
- Mask key labels by using the new masks TBKEYLABL (for key labels on tables) and SGKEYLABL (for key labels on storage groups).
New primary command to change the application compatibility level
PH22698 - May, 2020
You can use the new primary command APPLCOMPAT (or APPLC) to quickly change the application compatibility level. This command is equivalent to issuing the SET CURRENT APPLICATION COMPATIBILITY statement.
Support for inserting partitions
PH20648 - April, 2020
Db2 12 (FL500) allows you to insert partitions between or before existing logical partitions in partition-by-range universal table spaces (UTS). Db2 Admin Tool supports this new functionality. You can insert partitions by using either the AL line command or ALT line command and then specifying the new INS line command. Additionally, when you generate SQL to re-recreate an object or compare objects, those operations can both generate SQL to insert partitions.
CM batch option to generate JCL from a WSL
PH20257 - April, 2020
In Change Management (CM) batch, you can now generate JCL from a work statement list (WSL) by using the new parameter action_generate_jcl_from_wsl. The advantage of generating JCL is that you can review and edit the job before you submit it, whereas a WSL is not readable.
Ability to view a change that supersedes a change
PH22548 - March, 2020
When using Change Management, you can view the change that supersedes a change by using the new SBY line command on panel ADB2C11.
If a change cannot be run because the status was switched to DEFINED by a change that supersedes it, a message is returned that identifies the superseding change.
Exclusion of referential constraints when comparing objects with automatic target selection
PH22548 - March, 2020
This enhancement allows you to compare tables and apply the resulting changes without impacting referential integrity (RI) relationships. When you request a comparison with the following specifications, referential constraints are excluded from the comparison:
- specify the scope as table
- specify that the target is to be automatically selected
- request that the compare process run in CMDELTA mode
- do not suppress the drop of objects
In this case, referential constraints are not dropped in the target when the source does not include the referential constraints.
Conversion of ADB table spaces to UTS
PH22548 - March, 2020
Db2 12 FL 504 Beginning in Db2 12 function level 504, you can no longer create non-universal table spaces. This table space type is deprecated. To support this strategic direction to use only the universal table space (UTS) type, all Db2 Admin Tool (ADB) table spaces are converted to UTS when you run IBM Tools Customizer for z/OS (TCz) and select the option Convert Admin table spaces to UTS. The resulting customization job includes running the REORG utility to materialize the change for existing non-UTS table spaces.
Ability to view logical partition numbers and row counts for partitions
PH23202 - March, 2020
For partitioned tables and table spaces, you can now view logical partition numbers and the number of rows in each partition:
- On the Table Space Parts for table-space (ADB21SP) panel, you can now scroll to view all columns of the SYSTABLEPART catalog table for the selected table space, including the LOGICAL_PART and CARD (row counts) catalog columns.
- The table detail report is enhanced to include the logical partition numbers and row counts in the limit key section of the report. You can view this report by using the DET or BET commands on a partitioned table on the Tables, Views, and Aliases (ADB21T) panel.
Improvements to CM recovery
PH21635 - March, 2020
To ensure data integrity when using Change Management (CM), the process of generating and using recover changes is improved as follows:
- When generating a recover change during the analyze process, CM generates an UNLOAD statement for all tables that have column changes so that these tables can be recovered to the same point (with the existing or original data).
- When recovering with the original data, the data in the table is removed before the original data is loaded. This behavior prevents the duplication of data if ALTER operations were done as part of the recover change.
- When recovering multiple objects with the original data, all tables that need to be unloaded are placed in read-only mode at the same time so that the tables are logically consistent when they are recovered.
Bind Manager functionality added
PH18439 - March, 2020
The BNDAVB3 program from IBM Db2 Bind Manager for z/OS is integrated into Db2 Admin Tool and renamed ADBBMA3.
ADBBMA3 determines whether a bind is required for an application on which the bind avoidance program ADBBMAV has already been run and therefore, precompiling the application again is not necessary. (ADBBMAV runs the Db2 precompiler.) For example, if you run ADBBMAV on an application and then migrate that application to a different subsystem, only a bind is necessary. In this case, you can run ADBBMA3 on the application.
(ADBBMAV was previously integrated into Db2 Admin Tool by PH06267.)
Plan names displayed on ADB21K
PH16874 - March, 2020
The Packages (ADB21K) panel is enhanced to display the applicable plan name when displaying a package list for a plan.
ADBTEP2 can automatically retry failed statements
PH20650 - February, 2020
ADBTEP2 can automatically retry statements that fail due to timeouts when waiting on resources. To control retry behavior for ADBTEP2, use the new CM Batch parameters adbtep2_timeout_retries and adbtep2_timeout_wait_time or specify values on the Batch Job Utility Parameters (ADB2UPA) panel.
