Skip to main content

This article explains how to bind a compiled application with a DB2 collection ID of greater than eight characters without truncating the collection ID.

Problem:

Bind fails for a compiled application, and the collection ID truncates at eight characters. For example: 

SQL0061W The binder is in progress. 
SQL30104N Error in BIND or PRECOMPILE option "LANGLEVEL 
    	" with value "". SQLSTATE=56095 
SQL0082C An error has occurred which has terminated processing.
SQL0092N No package was created because of previous errors. 
SQL0091N Binding was ended with "3" errors and "0" warnings.

Resolution:

Compile and bind your application as follows:


  1. At a UNIX command prompt, enter the following to compile the application using the DB2(UDB-VERSION) compiler directive:

    DB2(UDB-VERSION=version)

    Where version is one of the following:

    Version Description
    V8 DB2 version 8.x
    V9 DB2 version 9.1
    V95 DB2 version 9.5
    Note: To determine the version of your DB2 client software, enter db2level. When you are connecting to a DB2 for z/OS database and using DB2 LUW version 9.5, db2level is not aware of LUW.
  2. Enter the following to bind the application using the file descriptor tool:

    DB2BFD -B CBDDB2C0.bnd

    The LANGLEVEL is no longer set in the PRECOMPILE options. This prevents the collection ID from being truncated.

Incident Number: 2258604,2257983

Old KB# 14267
Terms & ConditionsAccessibility statement