DB2 - Problembeschreibung
Problem IC76388 | Status: Geschlossen |
SQLJ.DB2_INSTALL_JAR AND SQLJ.DB2_REPLACE_JAR ARE NOT WORKING FOR LUW SERVER USING CLP. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
SQLJ.DB2_INSTALL_JAR and SQLJ.DB2_REPLACE_JAR work for local as well as remote LUW server using CLI for db2_v97fp3 client. CLP supports only those SQLJ.* procedures which are supported by sqleproc() API and these two sqlj.db2_* procedures are not supported by sqleproc() API. For these two procedures, CLP should go through CLI. CLP should also support these procedures. Call for these procedures using CLI is working fine. Following CLP commands fails: db2 -v "call sqlj.install_jar('file:/home/hotelfvt05/bimaljha/test.jar', 'TEST_JAR')" db2 -v "call sqlj.replace_jar('file:/home/hotelfvt05/bimaljha/test1.jar', 'TEST_JAR')" | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All who uses CLP. * **************************************************************** * PROBLEM DESCRIPTION: * * Following CLP commands fails with error for LUW server: * * * * db2 -v "call * * sqlj.install_jar('file:/home/hotelfvt05/bimaljha/test.jar', * * 'TEST_JAR')" * * * * db2 -v "call * * sqlj.replace_jar('file:/home/hotelfvt05/bimaljha/test1.jar', * * 'TEST_JAR')" * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v97fp5. * **************************************************************** | |
Local-Fix: | |
Use CLI or JAVA or Optim. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
db2_v97fp5 contains fix. After fix, command executes successfully. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.05.2011 12.12.2011 12.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |