PI08731: ADBBIND SQLCODEN206 ADBTEP2 ADBCSRV

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' install template ADBBIND
  job fails with a SQLCODE -206 / SQLCODEN206 for the BIND's
  of packages ADBTEP2 and ADBCSRV:
   DSNX200I  -ssid BIND SQL ERROR
              USING >authid< AUTHORITY
              PLAN=(NOT APPLICABLE)
              DBRM=ADBTEP2
              STATEMENT=10930
              SQLCODE=-206
              SQLSTATE=42703
              TOKENS=TBSCHEMA
              CSECT NAME=DSNXORSO
              RDS CODE=-100
  and other due to the prior versions maintenance not being
  current.
  

Local fix

• Apply all of the currently available maintenance to the prior
  release and ensure all of the ++HOLD instructions are carried
  out.
  

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 an UPGRADE job     *
  *                      template ADBMCMA that will upgrade      *
  *                      back-level DB2 Administration Tool      *
  *                      objects to the current maintenance      *
  *                      level, hence ensuring no objects or     *
  *                      columns are missing which can lead to   *
  *                      an SQLCODE=-206 / SQLCODEN206 at BIND   *
  *                      time via job template ADBBIND.          *
  *                                                              *
  *                      Also, no SADBSAMP members or cumbersome *
  *                      instructions are needed to supplement   *
  *                      the UPGRADE job for Change Management   *
  *                      (CM).  Otherwise, if a CM related       *
  *                      UPGRADE SADBSAMP job did exist and was  *
  *                      inadvertently not applied, this could   *
  *                      also lead to an SQLCODE=-206 /          *
  *                      SQLCODEN206 from job template ADBBIND.  *
  *                                                              *
  *                      The UPGRADE job template ADBMCMA also   *
  *                      has provisions to tolerate possible     *
  *                      SQLCODE = -601 / SQLCODEN601, SQLCODE   *
  *                      = -612 / SQLCODEN612 or SQLCODE = 562   *
  *                      / SQLCODE562 and not fail with RC=8 /   *
  *                      RC8 when these SQLCODEs are             *
  *                      encountered.                            *
  *                                                              *
  *                      Instead, a brief/simple informational   *
  *                      message ADB5179I / msgadb5179i 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  *
  *                      DB2 Administration Tool for z/OS        *
  *                      Version 11, Release 1 SADBSAMP jobs     *
  *                      are no longer required and have been    *
  *                      disabled:                               *
  *                                                              *
  *                      SADBSAMP(ADBCHG01)                      *
  *                      SADBSAMP(ADBCHG02)                      *
  *                      SADBSAMP(ADBCHG03)                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The UPGRADE option for the Change Management Database task has
  been enhanced to generate an UPGRADE job template ADBMCMA that
  will upgrade back-level DB2 Administration Tool objects to the
  current maintenance level, hence ensuring no objects or
  columns are missing which can lead to an SQLCODE = -206 /
  SQLCODEN206 at BIND time via job template ADBBIND.
  
  Also, no SADBSAMP members or cumbersome instructions are
  needed to supplement the UPGRADE job for Change Management
  (CM).  Otherwise, if a CM related UPGRADE SADBSAMP job did
  exist and was inadvertently not applied, this could also lead
  to an SQLCODE=-206 / SQLCODEN206 from job template ADBBIND.
  
  The UPGRADE job template ADBMCMA also has provisions to
  tolerate possible SQLCODE = -601 / SQLCODEN601,SQLCODE = -612
  / SQLCODEN612 or SQLCODE = 562 / SQLCODE562and not fail with
  RC=8 / RC8 when these SQLCODEs are encountered.
  
  Instead, a brief/simple informational message ADB5179I
  / msgadb5179i will be displayed in the job output.
  
  ADB5179I An expected sqlcode -612 was encountered and
  can be ignored. No action needed.
  
  Due to this enhancement, the following DB2 Administration Tool
  for z/OS Version 11, Release 1 SADBSAMP jobs are no longer
  required and have been disabled:
  
  SADBSAMP(ADBCHG01)
  SADBSAMP(ADBCHG02)
  SADBSAMP(ADBCHG03)
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• ADBBND01
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17985

     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.