DB2 - Problem description
Problem IC66619 | Status: Closed |
DB2 INSTALLATION COPIES DB2JCC_LICENSE_CUSIZ.JAR AS DB2JCC_LICENSE_CU.JAR OVERWRITING EXISTING DB2JCC_LICENSE_CU.JAR | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
DB2 installation copies db2jcc_license_cusiz.jar as sqllib\java\db2jcc_license_cu.jar overwriting existing sqllib\java\db2jcc_license_cu.jar if db2jcc_license_cusiz.jar exists in the db2\license directory in the installation directory. This may cause unexpected results such as, being able to connect to remote mainframe systems eventhough a file with name db2jcc_license_cusiz.jar is not in the CLASSPATH. Reproduction steps: 1.- Before installation starts: Copy db2jcc_license_cusiz.jar license file to db2\license directory under the installable image directory. 2.- Run setup.exe and perform the installation. 3.- The following is observed after installation: - a file db2jcc_license_cu.jar exists in path: <db2 directory>\SQLLIB\java - environment variable CLASSPATH contains <db2 directory>\SQLLIB\java\db2jcc_license_cu.jar - CLASSPATH does NOT contain db2jcc_license_cusiz.jar 4.- Test: Result: A test JAVA program that connects to a remote db2 mainframe database using IBM JDBC Type 4 Driver succeed. Expected result: An error was expected indicating that connection can not succeed because there is no valid license (db2jcc_license_cusiz.jar) to connect to the DB2 on the mainframe. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 installation copies db2jcc_license_cusiz.jar as * * * * sqllib\java\db2jcc_license_cu.jar overwriting existing * * * * sqllib\java\db2jcc_license_cu.jar if * * db2jcc_license_cusiz.jar * * exists in the db2\license directory in the installation * * * * directory. * * * * * * * * This may cause unexpected results such as, being able to * * connect * * to remote mainframe systems eventhough a file with name * * * * db2jcc_license_cusiz.jar is not in the CLASSPATH. * * * * * * * * Reproduction steps: * * * * * * * * 1.- Before installation starts: * * * * * * * * Copy db2jcc_license_cusiz.jar license file to db2\license * * * * directory under the installable image directory. * * * * * * * * 2.- Run setup.exe and perform the installation. * * * * * * * * 3.- The following is observed after installation: * * * * * * * * - a file db2jcc_license_cu.jar exists in path: * * * * <db2 directory>\SQLLIB\java * * * * * * * * - environment variable CLASSPATH contains * * * * <db2 directory>\SQLLIB\java\db2jcc_license_cu.jar * * * * * * * * - CLASSPATH does NOT contain db2jcc_license_cusiz.jar * * * * * * * * 4.- Test: * * * * * * * * Result: * * * * * * * * A test JAVA program that connects to a remote db2 * * mainframe * * database using IBM JDBC Type 4 Driver succeed. * * * * * * * * Expected result: * * * * * * * * An error was expected indicating that connection can not * * * * succeed because there is no valid license * * * * (db2jcc_license_cusiz.jar) to connect to the DB2 on the * * * * mainframe. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fixpak 3 * **************************************************************** | |
Local Fix: | |
Do not copy the db2jcc_license_cusiz.jar file to the db2\license folder in step 1. That way the test on Step 4 will fail until you add the db2jcc_license_cusiz.jar license file to the CLASSPATH. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in DB2 version 9.7 Fixpak 3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.02.2010 23.09.2010 23.09.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.3 | |
9.7.0.3 |