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 IC84584 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 / A10 - 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:                                              * 
* CLI users binding the CLI packages.                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 10.1.1                                        * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
From v10.1 FP1 CLI package binding throw the warnings instead of 
throwing errors and treating them as warnings in output.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.06.2012
02.11.2012
02.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList