I am receiving message DSNX105I SQL CODE = -206 when running DB2 BIND JCL RX90BIND. Is this normal?

Products

• CA Optimizer/II
• CA SymDump for CICS
• CA SymDump Batch

Issue/Introduction

Description:

When running bind JCL member RX90BIND the job ends with a return code of 4 with message DSNX105I +DB2P BIND SQL WARNING SQLCODE=-206. Is this return code allowed.

Solution:

This message is allowed when doing the DB2 bind for products CA SymDump Batch or CA Optimizer/II. The message generated is

 DSNX105I +DB2P BIND SQL WARNING
      USING TSXTCXJ AUTHORITY
      PLAN=(NOT APPLICABLE)
      DBRM=CAODDB8S
      STATEMENT=652
      SQLCODE=-206
      SQLSTATE=42703
      TOKENS=STATEMENT

This is caused by the code added for DB2 10.1 support which has new column names which does not exist in prior DB2 support (9.1 or lower).

This is not a functional problem because the statements that reference the new 10.1 columns will never be executed with older releases.

The message DSNX105I and SQL CODE = -206 can be ignored if you have a level of CA Optimizer/II or CA SymDump Batch that contains the DB2 10.1 compatibility code and you are running a release of DB2 prior to 10.1.

Environment

Release: OPTIM200200-8.5-Optimizer/II
Component: