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.