PI15252: ENHANCE THE CM DATABASE UPGRADE JOB TO TOLERATE SPECIFIC SQLCODES AND NOT SHOW AS ERRORS.

Obtain the fix for this APAR.

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 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

• RA20 PSY UI17985

     UP14/05/17 P F405

• RB10 PSY UI17986

     UP14/05/17 P F405

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.