A fix is available
APAR status
Closed as new function.
Error description
Enhance the CM Database UPGRADE job to tolerate specific SQLCODEs and not show as errors.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * IBM Tools Customizer for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The UPGRADE option for the Change * * Management Database task has been * * enhanced to generate a job template * * ADBMCMA that will upgrade back-level * * DB2 Administration Tool objects to * * the current maintenance level. * * * * The UPGRADE job template ADBMCMA also * * has provisions to tolerate possible * * SQLCODE = -601 / SQLCODEN601, * * SQLCODE = -612 / SQLCODEN612, or * * SQLCODE = 562 / SQLCODE562 errors * * and not fail with RC=8 / RC8 when * * these SQLCODEs are encountered. * * Instead, a brief/simple informational * * message ADB51791I / msgadb51791i will * * be displayed in the job output. * * * * For example, if SQLCODE = -612 is * * encountered, the following message * * will appear in the job output: * * * * ADB5179I An expected sqlcode -612 was * * encountered and can be ignored. No * * action needed. * * * * Due to this enhancement, the following * * SADBSAMP jobs are no longer required * * and have been disabled: * * * * DB2 Administration Tool for z/OS * * Version 10, Release 2: * * SADBSAMP(ADBCHANU) * * SADBSAMP(ADBCHG01) * * SADBSAMP(ADBCHG02) * * SADBSAMP(ADBCHG03) * * SADBSAMP(ADBCHG04) * * SADBSAMP(ADBCHG05) * * SADBSAMP(ADBCHG06) * * * * DB2 Administration Tool for z/OS * * Version 11, Release 1: * * SADBSAMP(ADBCHG01) * * SADBSAMP(ADBCHG02) * * SADBSAMP(ADBCHG03) * **************************************************************** * RECOMMENDATION: * **************************************************************** The UPGRADE option for the Change Management Database task has been enhanced to generate a job template ADBMCMA that will upgrade back-level DB2 Administration Tool objects to the current maintenance level. The UPGRADE job template ADBMCMA also has provisions to tolerate possible SQLCODE = -601 / SQLCODEN601, SQLCODE = -612 / SQLCODEN612, or SQLCODE = 562 / SQLCODE562 errors and not fail with RC=8 / RC8 when these SQLCODEs are encountered. Instead, a brief/simple informational message ADB51791I / msgadb51791i will be displayed in the job output.
Problem conclusion
Temporary fix
Comments
Problem has been resolved.
APAR Information
APAR number
PI15252
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-04
Closed date
2014-05-14
Last modified date
2014-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB$$PRM ADB$$SEQ ADBBND01 ADBCDCH ADBCFGPM ADBCHANG ADBCHANU ADBCHG01 ADBCHG02 ADBCHG03 ADBCHG04 ADBCHG05 ADBCHG06 ADBCHU01 ADBCMBAT ADBCMBIV ADBCMBSS ADBCUST ADBCX10 ADBFB2VB ADBGC10 ADBLIM ADBMCMA ADBMCMB ADBOPTS ADBOPT1 ADBOPT10 ADBOPT2 ADBOPT3 ADBOPT4 ADBOPT5 ADBOPT6 ADBOPT7 ADBOPT8 ADBOPT9 ADBTEP2R ADBUPGRD ADB5000 H0IHA20J H0IHB10J
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 June 2014