|
Problem IC67562
|
Status: Closed |
SQL0906N ERROR AFTER REBOUND WITH REOPT OPTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After the customer rebound the package with REOPT option, WAS
JDBC application got -4225 error.
Customer did the followings;
1. db2 bind db2clipk.bnd collection NULLIDRA
2. set Datasource's currentPackageSet to NULLIDRA
3. execute java application from WAS
Then got the following error;
jcc Thread:main SQLException@2dae2dae java.sql.SQLException
jcc Thread:main SQLException@2dae2dae SQL state = 24514
jcc Thread:main SQLException@2dae2dae Error code = -4225
Stack trace at jcc level 3.57.82
jcc Thread:main SQLException@6aee6aee Stack trace follows
com.ibm.db2.jcc.am.SqlException: jcc 10429 12554 3.57.82
A processing error occurred on the server which resulted in an
unrecoverable error.
Please set deferPrepares property to false and re-establish the
connection. If the problem still persists, please contact
support. ERRORCODE=-4225, SQLSTATE=24514
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:120)
at com.ibm.db2.jcc.am.km.a(km.java:2004)
at com.ibm.db2.jcc.t4.db.m(db.java:769)
at com.ibm.db2.jcc.t4.db.i(db.java:245)
at com.ibm.db2.jcc.t4.db.c(db.java:53)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:147)
at com.ibm.db2.jcc.am.km.gb(km.java:1985)
at com.ibm.db2.jcc.am.lm.b(lm.java:3576)
at com.ibm.db2.jcc.am.lm.Vb(lm.java:654)
at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.
executeQuery(PreparedStatementWrapper.java:71)
- - - |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* After the customer rebound the package with REOPT *
* option,WASJDBC application got -4225 error. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem was first fixed in Version 9.7 FP1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.03.2010
13.05.2010
13.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
