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

THE MODIFICATION LEVEL OF THE PRODUCT IDENTIFIER IN DB2 LUW 9.1.11 IS
CHARACTER "B".

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The modification level of the product identifier in DB2 LUW 
9.1.11 is character 'B' to indicate fixpack value 11. Product 
identifier for v9.1.11 is SQL0901B. 
 
DB2 Connect Users: DB2 zOS APAR PM35785  should be 
installed on their z/OS systems to display v9.1.11 fixpack value 
'B'.  Without APAR PM35785, 
zOS server will display SQL09019 instead of SQL0901B. 
 
DB2 LUW remote client and server combination, those can not 
handle Alpha Modification level, will still display '9'  to 
indicate fixpack for v9.1.11 server or client. 
 
DB2 LUW Client   v9.1.11 Server   Server's product id 
                                                 display on 
client/driver 
 
9.7.5 or below   SQL0901B              SQL09019 
9.5.8 or below   SQL0901B              SQL09019 
9.1.10or below   SQL0901B              SQL09019 
 
 
v9.1.11client Productid Server Product version    Client's 
Product 
 
   identifier display on server 
 
 
SQL0901B    9.7.5   or below                      SQL09019 
SQL0901B    9.5.8   or below                      SQL09019 
SQL0901B    9.1.10 or below                       SQL09019 
 
 
See the following link for Product identifier Architecture. 
1. What's new for V9.1 FP1: Modification level of product 
identifier can contain alphanumeric characters 
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm 
.db2.udb.rn.doc/doc/c0024951.htm 
 
 
2. Version 9 incompatibilities with previous releases and 
changed behaviors 
Modification level of product identifier can contain 
alphanumeric characters 
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm 
.db2.udb.admin.doc/doc/c0022778.htm 
 
 
3:DB2 Connect Version 9.1 fix packs summary 
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm 
.db2.udb.rn.doc/doc/c0025089.htm
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgarde to v9.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
APAR handles alpha mod in productid eg for V9.1.11, productid is 
SQL0901B. 'B" represent fixpack or mod. If APAR is not applied, 
DB2 LUW client/server can not handle ALPHA mod value.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.09.2011
06.06.2012
06.06.2012
Problem solved at the following versions (IBM BugInfos)
9.1.11,
9.7.6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList