PM85491: DSNX200I BIND SQL ERROR SQLCODEN206 TOKENS=APPCONT DSNT233I UNSUCCESSFUL BIND FOR PACKAGE ADBL.ADBCSRV

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS install process can result
  in SQLCODEN206 / SQLCODE -206 BIND errors for the Change
  Management feature related package ADBL MEMBER(ADBCSRV).
  

Local fix

• Add these 3 Alters to the SAMP member ADBCHANU.
   ALTER  TABLE ADBCHG
     ADD APPCONT     CHAR(1) NOT NULL WITH DEFAULT;
  
   ALTER  TABLE ADBCHG
     ADD IDENTSVL    CHAR(1) NOT NULL WITH DEFAULT;
  
   ALTER  TABLE ADBCHG
     ADD SEQSVLR     CHAR(1) NOT NULL WITH DEFAULT;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When upgrading the Change Management    *
  *                      Database from DB2 Administration Tool   *
  *                      for z/OS Version 7.2 to Version 10.2,   *
  *                      the following BIND error will occur     *
  *                      when submitting job ADBBIND:            *
  *                                                              *
  *                      BIND PACKAGE(ADBL) -                    *
  *                        MEMBER(ADBCSRV) -                     *
  *                        QUALIFIER(DB2PROG) -                  *
  *                        VALIDATE(BIND) -                      *
  *                        ISOLATION(CS) -                       *
  *                        RELEASE(C) -                          *
  *                        ENCODING(EBCDIC)  -                   *
  *                        EXPLAIN(NO)                           *
  *                                                              *
  *                      DSNX200I  -DB2M BIND SQL ERROR          *
  *                                 USING UTIL0 AUTHORITY        *
  *                                 PLAN=(NOT APPLICABLE)        *
  *                                 DBRM=ADBCSRV                 *
  *                                 STATEMENT=872                *
  *                                 SQLCODE=-206                 *
  *                                 SQLSTATE=42703               *
  *                                 TOKENS=APPCONT               *
  *                                 CSECT NAME=DSNXORSO          *
  *                                 RDS CODE=-100                *
  *                      DSNT233I  -DB2M UNSUCCESSFUL BIND FOR   *
  *                      PACKAGE =                               *
  *                      DB2M.ADBL.ADBCSRV.(V10.2.0.0000000)     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This BIND error was due to 3 missing columns to the Change
  Management Database ADBCHG:
  
  APPCONT
  IDENTSVL
  SEQSVLR
  

Problem conclusion

• Problem has been resolved.
  Submit SAMP library member SADSAMP(ADBCHANU).
  

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:

  UK93458

Modules/Macros

•    ADBCHANU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK93458

     UP13/04/18 P F304

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.