SQLCODE -206 during BIND Job due to missing column DB2 tables

book

Article ID: 220524

calendar_today

Updated On:

Products

DB2 TOOLS- DATABASE MISC

Issue/Introduction

Found several SQLCODE -206 in BIND Job in Post-Install Tasks because of columns still not defined in the DB2 tables. 
  
BIND PACKAGE ( ... )
...
VALIDATE   ( RUN )
  
Got a warning message with SQLCODE=-206. 
 
DSNX105I  = BIND SQL WARNING 

Environment

Release : 20.0

Component : DB2 Common Components

Resolution

Many of our Packages are designed to handle different levels of DB2, as long as the Bind Job finished with a RC=04 the Bind Job is fine. The BIND PACKAGE statement has a VALIDATE   ( RUN ) so the BIND Job finished with RC=04 although the SQLCODE -206 error.

The warning messages are indicating that not all the referenced DB2 objects have been created yet. For example for tables that have been superseded, but the Package still references them for back level support. This applies to both the CA defined tables and DB2 system tables. The warnings can also occur for DB2 system tables that are not yet defined.