PH25570: BIND OF DBRM ADBTEP2 SQLCODE = -206 SQLCODEN206 STATEMENT 8443 TOKEN LTRANSACTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running ADBBIND may result in the
  following bind error on DBRM ADBTEP2:
  
  
  DSNX200I  #ssid BIND SQL ERROR.
             USING sqlid AUTHORITY.
             PLAN=(NOT APPLICABLE).
             DBRM=ADBTEP2.
             STATEMENT=8443.
             SQLCODE=-206.
             SQLSTATE=42703.
             TOKENS=LTRANSACTION.
             CSECT NAME=DSNXORSO.
             RDS CODE=-100.
  
  
  
  Keywords: SQLCODEN206
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS who bind the ADBTEP2 DBRM.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running a bind job on the ADBTEP2       *
  *                      DBRM ends with RC04 but contains        *
  *                      SQLERROR -206.                          *
  ****************************************************************
  The job for binding the ADBTEP2 DBRM might return the
  following SQL error:
  
  DBRM=ADBTEP2
  STATEMENT=8473
  SQLCODE=-206
  SQLSTATE=42703
  TOKENS=LTRANSACTION
  CSECT NAME=DSNXORSO
  RDS CODE=-100
  
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

Problem conclusion

• The 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:

  UI70491

Modules/Macros

• ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70491

     UP20/07/14 P F007

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.