|
Problem IC81469
|
Status: Closed |
QUERY FAILED WITH SQL4228 ERROR IN DPF ENVIRONMENT. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
A select statement executed through JDBC T4 failed with Error
code = -4228
error in DPF environment.
The following is an example of the error in the jcc trace.
[jcc][Time:2012-02-03-13:25:32.747][Thread:main][ResultSet@18d51
8d5] next () called
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:main][SQLException@42e042e] java.sql.SQLException
[jcc][Thread:main][SQLException@42e042e] SQL state = null
[jcc][Thread:main][SQLException@42e042e] Error code = -4228
[jcc][Thread:main][SQLException@42e042e] Message =
[jcc][t4][2093][11302][3.53.95]
Query processing has been terminated due to error on the
server. ERRORCODE=-4228, SQ
LSTATE=null
[jcc][Thread:main][SQLException@42e042e] Stack trace follows
com.ibm.db2.jcc.b.SqlException: [jcc][t4][2093][11302][3.53.95]
Query processing has
been terminated due to error on the server. ERRORCODE=-4228,
SQLSTATE=null
at com.ibm.db2.jcc.b.bd.a(bd.java:660)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:120)
at com.ibm.db2.jcc.t4.d.B(d.java:1895)
at com.ibm.db2.jcc.t4.d.wb(d.java:2075)
at com.ibm.db2.jcc.t4.d.cb(d.java:601)
at com.ibm.db2.jcc.t4.d.b(d.java:846)
at com.ibm.db2.jcc.t4.d.a(d.java:819)
at com.ibm.db2.jcc.t4.d.b(d.java:401)
at com.ibm.db2.jcc.b.gc.a(gc.java:219)
at com.ibm.db2.jcc.b.vl.c(vl.java:355)
at com.ibm.db2.jcc.b.vl.next(vl.java:291)
at JdbcTest.main(JdbcTest.java:111)
[jcc] END TRACE_DIAGNOSTICS
It is not the issue for JDBC.
If the same SQL is executed locally on Server, SQL30020 will be
returned to the query.
The customer may hit this issue when all of the following
conditions are satisfied.
1. DPF environment.
2. The database has a table having NOT NULL column in the
tablespace created on only one node.
3. The query retrieves data from the table described in the
condition 2. And also it is executed on the node described in
the condition 2. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.5 Fix Pack 10. *
**************************************************************** |
| Local Fix: |
Make tables distributed over multiple nodes. |
| Solution |
Problem was first fixed in DB2 UDB Version 9.5 Fix Pack 10. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC81493
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.02.2012
22.08.2012
02.04.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.10
|
 |
