|
Problem IC76388
|
Status: Closed |
SQLJ.DB2_INSTALL_JAR AND SQLJ.DB2_REPLACE_JAR ARE NOT WORKING FOR LUW SERVER USING CLP. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
db2_v97fp5 contains fix. After fix, command executes
successfully. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.05.2011
12.12.2011
12.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
