A fix is available
APAR status
Closed as program error.
Error description
User is running an apply with ADBTEP2 to create a foreign key and it issues ADB7955E error message on SQLCODE = 162. Description of ADB7955E states: Processing fails and stops This was not the case, the apply job ended with CC=4.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When using ADBTEP2, the user receives * * error message ADB7955E even though the * * job receives SQL code +162 (a warning). * * The user expected warning message * * ADB7954W to be issued instead. * **************************************************************** The user runs an apply job with ADBTEP2 to create a foreign key and receives a +162 SQL code warning that a table space is in check pending. Db2 Admin Tool issues an error message, ADB7955E which is a generic ADMIN error message, along with that warning. The user expected a warning message, such as ADB7954W which is the generic ADMIN warning message, instead.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH50508
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
2022-10-31
Closed date
2023-02-05
Last modified date
2023-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBTEP2
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":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 March 2023