Package Binds using CA-Gen: Package Bind Failed, RC=4

Products

• Gen

Issue/Introduction

Migrating model and then generating and installing a p-step, error message occurs:

          PACKAGE BIND FAILED, RC=4  

Environment

CA GEN release 8.6

 

Resolution

The DB2 tables were created on DB2v10 or before and are trying to bind these to DB2v11 or higher.

This results in a deprecated feature of EXPLAIN in the Tables definition format being used.

The table was created with a format that is no longer supported by EXPLAIN. But the EXPLAIN tables are populated as usual.

That's the reason the error message occurred when the EXPLAIN Parm is set to YES, but still it does a successful bind.

Recommendation is to recreate the definition of the tables with the latest version which is being used or use DB2 EXPLAIN parm set to NO.