DB2 FOR LUW / DB2FORLUW / 950 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 10.                          * 
****************************************************************

Make tables distributed over multiple nodes.

Problem was first fixed in DB2 UDB Version 9.5 Fix Pack 10.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC81493 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.02.2012
22.08.2012
02.04.2014

9.5.FP10