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 IC62388 Status: Closed

ISSUING THE PREP OR BIND COMMAND ON DB2 V9.5.3 AND DB2 V9.5.4 WITH THE
BINDFILE OPTION CAN LEAD TO AUTHORIZATION ERRORS.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
There is no package created in the database when the BINDFILE 
option is specified on the PREP or BIND commands. In DB2 Version 
9.5 Fix Pack 3 and DB2 Version 9.5 Fix Pack 4 a user issuing 
those commands will receive an authorization error if they do 
not have the necessary privileges to create a package. However, 
because a package is not created, the correct behaviour is to 
let the statement succeed.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 systems on all Linux, Unix and Windows platforms at  * 
* service levels from Version 9.5 Fix Pack 3 through to        * 
* Version 9.5 Fix Pack 4.                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Please see Error Description.                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 5.                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The complete fix for this problem first appears in DB2 Version 
9.5 Fix Pack 5 and all the subsequent Fix Packs.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.08.2009
24.02.2010
24.02.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.5 FixList