|
Problem IC78013
|
Status: Closed |
SQLJ.*_JAR AND SQLJ.DB2_*_JAR STORED PROCS CANNOT BE CALLED REMO TELY AGAINST HOST DATABASES (ZOS, ISERIES, ETC.) FROM NON-JCC CL |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When customer attempts to execute SQLJ.*_JAR or SQLJ.DB2_*_JAR
stored procedures from a DB2 LUW client against a host database,
the error that is returned is not very informative. An example
of such an uninformative error is:
SQL30073N "0x2113" Parameter value "0x0000" is not supported.
SQLSTATE=58017
This error gives the impression that one of the input parameters
passed in the stored procedure is not supported. These errors
have been altered to provide a more informative error:
SQL1325N The remote database environment does not support the
command or one of the command options.
This is because the calling of SQLJ.*_JAR stored procedures
against host databases is not supported regardless of the
connection
type used. SQLJ.DB2_*_JAR stored procedures on the other hand
can
be called via JCC clients against host databases. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users connecting to host databases *
****************************************************************
* PROBLEM DESCRIPTION: *
* SQLJ.*_JAR and SQLJ.DB2_*_JAR stored procedures cannot be *
* called remotely against host databases (zOS, iSeries, etc.) *
* from non-JCC Clients. If called, the error returned is not *
* very informative. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 fp6 *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
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 |
The error messages have been altered so that the following,
more informative error is dumped:
SQL1325N The remote database environment does not support the
command or one of the command options. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.08.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
