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

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

product:
DB2 FOR LUW / DB2FORLUW / 910 - 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:                                         * 
* The modification level of the product identifier in DB2 LUW  * 
* 9.1.11 is character "B" to indicate fixpack value 11.        * 
*                                                              * 
* Note for DB2 Connect Users:DB2 zOS APAR PM35785 must be      * 
* installed on their z/OS systems first, before upgrading      * 
* DB2Connect client/driver on  db2_v91fp11.                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* The modification level of the product identifier in DB2 LUW  * 
* 9.1.11 is character "B" to indicate fixpack value 11.        * 
*                                                              * 
* Note for DB2 Connect Users:DB2 zOS APAR PM35785 must be      * 
* installed on their z/OS systems first, before upgrading      * 
* DB2Connect client/driver on  db2_v91fp11.                    * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
The modification level of the product identifier in DB2 LUW 
9.1.11 is character "B" to indicate fixpack value 11. 
 
Note for DB2 Connect Users:DB2 zOS APAR PM35785 must be 
installed on their z/OS systems first, before upgrading 
DB2Connect client/driver on  db2_v91fp11.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC78892 IC78893 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.08.2011
08.12.2011
08.12.2011
Problem solved at the following versions (IBM BugInfos)
9.1.11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList