home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList