PI64731: BIND FOR DSNATBLU RECEIVED SQLCODE206

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNE932I WARNING, ONLY IBM-SUPPLIED COLLECTION-IDS SHOULD BEGIN
  WITH  "DSN"
  DSNE932I WARNING, ONLY IBM-SUPPLIED PACKAGE-IDS SHOULD BEGIN
  WITH  "DSN"
  DSNX105I  -DB2A BIND SQL WARNING
             USING ADMF001 AUTHORITY
             PLAN=(NOT APPLICABLE)
             DBRM=DSNATBLU
             STATEMENT=5797
             SQLCODE=-206
             SQLSTATE=42703
             TOKENS=TYPE
  
  -206 on statement involving  SYSACCEL.SYSACCELERATEDTABLES
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS IDAA users which use     *
  *                 IBM Data Server Driver for JDBC and SQLJ     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Installation job DSNTIJRT job step      *
  *                      DSNTRIN returned BIND SQL WARNING       *
  *                      DSNX105I on DBRM DSNATBLU statement     *
  *                      5835 with SQLCODE=-206, SQLSTATE=42703, *
  *                      and TOKEN=TYPE from the BIND            *
  *                      PACKAGE(DSNASPCC)MEMBER(DSNATBLU)       *
  *                      request.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Install job DSNTIJRT job step DSNTRIN is used to bind package
  DSNATBLU for DatabaseMetadata procedure SYSIBM.SQLTABLES().
  When binding package DSNATBLU on DB2 11 for z/OS with IDAA
  enabled, the package was bound successfully, but DSNTRIN
  returned SQL WARNING DSNX105I on DBRM DSNATBLU statement 5835
  with SQLCODE=-206, SQLSTATE= 42703, and TOKENS=TYPE. SQL
  Statement 5835 is used by JDBC application when calling
  DatabaseMetaData method getTables().
  

Problem conclusion

• BIND SQL WARNING DSNX105I is corrected when binding package for
  DSNATBLU.
  

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:

  UI40537

Modules/Macros

• DSN@TBLU DSNATBLU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI40537

     UP16/09/16 P F609

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.