|
Problem IC81493
|
Status: Geschlossen |
QUERY FAILED WITH SQL4228 ERROR IN DPF ENVIRONMENT. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DPF *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Install Fix *
**************************************************************** |
| Local-Fix: |
Make tables distributed over multiple nodes. |
| verfügbare FixPacks: |
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
|
| Lösung |
Install Fix |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.02.2012
06.06.2012
06.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
