PI53708: DSNT243I BIND ERROR FOR PACKAGE <>.ADBL.ADBCCM.(V11.2.0.UI32385)CONTOKEN = '19F6ABD71633CC1C'X IS NOT UNIQ 15/12/08 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ADBBIND job ends with a
  message:
  BIND PACKAGE(ADBL)   MEMBER(ADBCCM)    OWNER(ADB)
  QUALIFIER(ADB)
  SQLERROR(CONTINUE)   VALIDATE(BIND)   ISOLATION(CS)   CURRENTDA
  TA(NO)   RELEASE(COMMIT)   ENCODING(EBCDIC)    EXPLAIN(NO)
  DSNT243I  -SSID BIND ERROR FOR
             PACKAGE = >location<.ADBL.ADBCCM.(V11.2.0.UI32385)
             CONTOKEN = '19F6ABD71633CC1C'X IS NOT UNIQUE
             SO IT CANNOT BE CREATED
  DSNT233I  -SSID UNSUCCESSFUL BIND FOR
             PACKAGE = >location<.ADBL.ADBCCM.(V11.2.0.UI32385)
  

Local fix

• Issue a FREE PACKAGE(ADBL.ADBCCM.(V11.2.0.PI50592)) statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and IBM Tools Customizer for        *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Job template 'ADBBIND - Binds'          *
  *                      received the following CONTOKEN         *
  *                      error with no instructions in           *
  *                      the job template ADBBIND                *
  *                      regarding how to resolve it:            *
  *                                                              *
  *                      BIND PACKAGE(>collection_id<)           *
  *                      MEMBER(>package<)                       *
  *                      OWNER(>owner<)                          *
  *                      QUALIFIER(>qualifier<)                  *
  *                      SQLERROR(CONTINUE)                      *
  *                      VALIDATE(BIND)                          *
  *                      ISOLATION(CS)                           *
  *                      CURRENTDATA(NO)                         *
  *                      RELEASE(COMMIT)                         *
  *                      ENCODING(EBCDIC)                        *
  *                      EXPLAIN(NO)                             *
  *                      DSNT243I  -DBT3                         *
  *                      BIND ERROR FOR                          *
  *                        PACKAGE =                             *
  *                        >location-name<.                      *
  *                        >collection_id<.                      *
  *                        >dbrm-name<.                          *
  *                        (V11.2.0.>version_id<)                *
  *                        CONTOKEN = '>contoken<'X              *
  *                        IS NOT UNIQUE SO IT                   *
  *                        CANNOT  BE CREATED                    *
  *                        DSNT233I  -DBT3                       *
  *                        UNSUCCESSFUL BIND                     *
  *                        FOR PACKAGE =                         *
  *                        >location-name<.                      *
  *                        >collection_id<.                      *
  *                       >dbrm-name<.                           *
  *                       (V11.2.0.>version_id<)                 *
  *                                                              *
  *                      Analysis showed that an APAR FIXTEST    *
  *                      that included a DBRM was applied which  *
  *                      requires a resubmit of job template     *
  *                      ADBBIND.  Unfortunately, the CONTOKEN   *
  *                      was not unique which resulted in the    *
  *                      above BIND error.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Job template 'ADBBIND - Binds' received a CONTOKEN error with
  no instructions in the job template ADBBIND regarding how to
  resolve it.
  
  Analysis showed that an APAR FIXTEST that included a DBRM was
  applied which requires a resubmit of job template ADBBIND.
  Unfortunately, the CONTOKEN was not unique which resulted in
  the BIND error.
  

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:

  UI34993

Modules/Macros

•    ADBBIND
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI34993

     UP16/02/04 P F602 Ø

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.