|
Problem IC81493
|
Status: Closed |
QUERY FAILED WITH SQL4228 ERROR IN DPF ENVIRONMENT. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A select statement executed trough JDBC T4 failed with SQL4228
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: *
* Install Fix *
**************************************************************** |
| Local Fix: |
Make tables distributed over multiple nodes. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Install Fix |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.02.2012
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
