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

CHANGES OF THE ENVIRONMENT VARIABLES BEING IGNORED WHEN APPLIED AFTER
APPLICATION LIBRARIES ARE LOADED.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
After implementation of IZ04276 the DB2 client application reads 
some environment variables(DB2NODES, DB2PATH, DB2INSTRPOF on 
unix and DB2NODES, DB2INSTDEF, DB2INSTANCE on windows) when 
loading the client library.   As a result , every change to the 
environment variables that are made by the application will be 
ignored.  This can affect some applications  (ie datastage).
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users that have columns that are used in a projection        * 
* clause.                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A select statement with 'group by' returns incorrect number  * 
* of rows when a column used in projection clause is updated.  * 
* That column is not used in the 'where' clause and no other   * 
* changes were made to the table.                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.5 fixpack 8 or higher.                  * 
****************************************************************
Local Fix:
available fix packs:
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
This is fixed in version 9.5 fixpack 8
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
18.01.2011
05.07.2011
05.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList