Gurus,

Installation: DB2 UDB-8.2 (8.1 with fixpack ...7a) on AIX-5.2

The application has access the data base for reading of a table and writing
in two others. The tables possess few data (little more than 1000 lines).

Your help is greatly appreciated.

TIA,

Garcia.

Error:
============================================================================
====
BOP:2004/10/21 09:12:10 Rep: R0043A Msg: Begin Report (Generate 2004/10/18)
BOT:2004/10/21 09:12:10 Rep: R0043A Msg: Begin Transaction (TraNo: 0.0)
BOT:2004/10/21 09:12:11 Rep: R0043A Msg: Begin Transaction (TraNo: 0.0)
ERR:2004/10/21 09:12:24 Rep: R0043A Msg: Fatal Error on LOGCL_Insert, Logic:
com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C
3031
at com.ibm.db2.jcc.b.ce.e(ce.java:1093)
at com.ibm.db2.jcc.a.bd.o(bd.java:564)
at com.ibm.db2.jcc.a.bd.g(bd.java:129)
at com.ibm.db2.jcc.a.bd.a(bd.java:40)
at com.ibm.db2.jcc.a.r.a(r.java:31)
at com.ibm.db2.jcc.a.bp.g(bp.java:141)
at com.ibm.db2.jcc.b.ce.h(ce.java:853)
at com.ibm.db2.jcc.b.ce.a(ce.java:1311)
at com.ibm.db2.jcc.b.ce.executeQuery(ce.java:253)
at R0043A.LOGCL_Insert(R0043A.java:3110)
at R0043A.Logic(R0043A.java:1616)
at R0043A.runReport(R0043A.java:1263)
at R0043A.main(R0043A.java:599) -- select IDENTITY_VAL_LOCAL() from
LOGCL FETCH FIRST 1 ROWS ONLY
EOT:2004/10/21 09:12:24 Rep: R0043A Msg: Aborted Transaction(Elapsed:
00:00:13:845hs
EOP:2004/10/21 09:12:24 Rep: R0043A Msg: Aborted Report (GLB.TASK=1)

=======================

sqlcode : -805
sqlstate : 51002

=======================


DB2 & UDB email list listserv db2-l LazyDBA home page