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 |