DB2 - Problembeschreibung
Problem IC78013 | Status: Geschlossen |
SQLJ.*_JAR AND SQLJ.DB2_*_JAR STORED PROCS CANNOT BE CALLED REMO TELY AGAINST HOST DATABASES (ZOS, ISERIES, ETC.) FROM NON-JCC CL | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.08.2011 05.06.2012 05.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |