A fix is available
APAR status
Closed as unreproducible in next release.
Error description
This APAR addresses 3 issues related to a Native Stored Procedure (NSP): 1) Object Compare may generate VALIDATE RUN instead of VALIDATE BIND in a WSL. 2) The following error is incorrectly issued when NSP changes are compared: ADB8007E An attempt was made to create a procedure that already exists. ADB8068I Partial statement at the point of error: No statement information, possibly an internally generated delta record ADB8057I Object details at the time of error: .... ADBCCME - Error(s) found. Please review output 3) An incorrect NSP version may be reported in the Compare summary report. Keywords: msgadb8007e; msgadb8068i; msgadb8057I
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool for * * z/OS and Object Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides fixes for the * * following issues related to native * * stored procedures (NSPs): * * * * 1. The Compare function may generate * * VALIDATE RUN * * instead of VALIDATE BIND in a work * * statement list (WSL) * * 2. Incorrect error message ADB8007E is * * issued when NSP changes are * * compared. * * 3. An incorrect NSP version may be * * reported in the Compare summary report. * **************************************************************** This APAR provides fixes for the following issues: 1. During a comparison, when new NSP versions are added to the source, Compare incorrectly overrides the NSP option VALIDATE BIND with VALIDATE RUN in CMDELTA mode. 2. The following error message is incorrectly issued when Change Management (CM) analyzes a registered change to an NSP that includes multiple versions and the inactive version V1: ADB8007E An attempt was made to create a procedure that already exists. 3. When the source and target NSPs are compared, and the active version in the source is different than the active version in the target, the Compare summary report might report an incorrect version of the NSP.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH29663
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-18
Closed date
2020-11-05
Last modified date
2020-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72418
Modules/Macros
ADB2CMS ADB2REP ADBCCMM
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI72418
UP20/12/01 P F011
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
12 February 2021