home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC81716 Status: Closed

WHILE BINDING CLI PACKAGES AN ERROR IS BEING THROWN AND IS BEING TREATED AS
WARNING , INSTEAD OF THROWING A WARNING!

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
While binding CLI packages only following bind options are valid 
:  ACTION, COLLECTION, CLIPKG, OWNER, and REPLVERit , using any 
other options in this context will be ignored. To let user know 
about this a warning message should be thrown , but currently , 
a message with error code SQL30104N is being thrown but it is 
being treated like warning i.e., invalid bind options are 
ignored and the processing is continued. 
 
                         db2 bind @ddcsmvs.lst blocking all 
sqlerror continue generic "\"rounding halfeven"\" 
 
                         SQL30104N  Error in BIND or PRECOMPILE 
option "GENERIC" with value "5691750".  SQLSTATE=56095 
 
    SQL0091N  Binding was ended with "0" errors and "63" 
                  warnings.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 users using BIND command with CLI packages.              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* hile binding CLI packages only following bind options are    * 
* valid :  ACTION, COLLECTION, CLIPKG, OWNER, and REPLVERit ,  * 
* using any                                                    * 
* other options in this context will be ignored. To let user   * 
* know about this a warning message should be thrown , but     * 
* currently ,                                                  * 
* a message with error code SQL30104N is being thrown but it   * 
* is being treated like warning.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.6                                 * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84584 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.02.2012
06.06.2012
06.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList