DB2 - Problembeschreibung
Problem IT06524 | Status: Geschlossen |
Java external routine which retrieves result set via Stored procedure call having cursor may return BugCheckException | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
BugCheckException error occurs when executing a Java external routine which is retrieving a result set via a stored procedure call having a cursor output parameter. Below error is seen: Stack trace collected from the db2dump: com.ibm.db2.jcc.am.BugCheckException: [jcc][t4][1026][12957][4.15.113] Bug check exception thrown due to an internal JCC error. Please contact support. Message text: {0} ERRORCODE=-4228, SQLSTATE=null at com.ibm.db2.jcc.am.hd.a(hd.java:599) at com.ibm.db2.jcc.am.hd.a(hd.java:616) at com.ibm.db2.jcc.am.lc.a(lc.java:2695) at com.ibm.db2.jcc.am.CallableStatement.J(CallableStatement. java:1137) at com.ibm.db2.jcc.am.CallableStatement.getObject (CallableStatement.java:1115) ... db2diag.log will contain full exception as: 2014-12-04-14.50.40.514000-300 I122272F1103 LEVEL: Warning PID : 9772 TID : 11420 PROC : db2fmp64.exe INSTANCE: ABC NODE : 000 DB : SAMPLE APPID : *LOCAL.ABC HOSTNAME: LOCALHOSTABC EDUID : 11420 FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10 DATA #1 : String, 630 bytes java.sql.SQLException: com.ibm.db2.jcc.am.BugCheckException: [jcc][t4][1026][129 57][4.15.113] Bug check exception thrown due to an internal JCC error. Please c ontact support. Message text: {0} ERRORCODE=-4228, SQLSTATE=null at com.ibm.db2.jcc.am.fd.a(fd.java:548) at com.ibm.db2.jcc.am.fd.a(fd.java:565) at com.ibm.db2.jcc.am.jc.a(jc.java:2695) at com.ibm.db2.jcc.am.CallableStatement.J(CallableStatement.java:11 33) at com.ibm.db2.jcc.am.CallableStatement.getObject(CallableStatement .java :1111) at SpServer.outLanguage(SpServer.java:52) -4228 : PREPARE STATEMENT FAILED at SpServer.outLanguage(SpServer.java:73) DATA #2 : Hexdump, 4 bytes 0x0000000010EA9300 : 0000 0000 .... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 FP7 * **************************************************************** | |
Local-Fix: | |
Below work around can be adopted: Replace procedure returning the cursor with a Table UDF returning the same result set. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.01.2015 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |