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 | |
| 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 |
|