Message DSNX105I SQL CODE = -206 occurs when running DB2 BIND JCL RX90BIND. Is this normal?

Products

• Optimizer/II
• SymDump for CICS
• SymDump Batch

Issue/Introduction

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.

Environment

Release: OPTIM200200-8.5-Optimizer/II
Component:

Resolution

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

 DSNX105I +DB2P BIND SQL WARNING
      USING authorization-id AUTHORITY
      PLAN=(NOT APPLICABLE)
      DBRM=dbrm name
      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 did not exist in prior DB2 releases (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 Optimizer/II or SymDump Batch that contains the DB2 10.1 compatibility code and you are running a release of DB2 prior to 10.1.