A fix is available
APAR status
Closed as program error.
Error description
Bug Smash 2023 (Phase 1)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides fixes to resolve * * the issues described in the summary * * below. * **************************************************************** This APAR includes the following fixes: 1. When a ROWID column is renamed as a result of a comparison by Object Compare, the work statement list (WSL) fails with ADBC107E "Error in old col numbers" during RUN PROGRAM(ADB27AC) statement processing. 2. When a Change Management (CM) batch job with ACTION_IMPORT_CHANGE set to 'Y' specifies an import data set with a logical record length (LRECL) greater than the supported length, ONCODE=21 is returned without an explanation of the issue. 3. If the parameter "Perform analysis in batch" is set to NO on the ADBP7P panel, the analysis has already been performed by the time the ADBPALT panel is displayed. Therefore, changing any option on the ADB2PCO panel has no effect and no warning is given about that behavior. 4. When running on Db2 13, Object Compare does not flag an error and stop processing if a clone table is present. This behavior causes a failure during the WSL execution. 5. When using the ADDV line command on a native SQL stored procedure and upon changing the version and 'parm name', error panel ADB2ER displays message ISPS107. 6. When issuing the DET line command on a REST service package on panel ADB21K 'Packages', the SQL statement associated with the selected REST service is not displayed. Also, Db2 Admin Tool 12.1 fixed the following additional problem that is already fixed in version 13.1: Using ALT to remove a column from the unique index that is partitioned and partitioning results in the index being dropped and not recreated.
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH58846
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-12-18
Closed date
2024-01-03
Last modified date
2024-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI95099 UI95100
Modules/Macros
ADB0 ADB21XAR ADB26COU ADB2CMT ADB2ISQ ADB2PCO ADB7000 ADB80
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2024