Hello All,

I had a query which was working fine when I was using DB2 legacy CLI-based Type 2 driver but when I switched to Universal JDBC driver, I got this error:

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH300
at com.ibm.db2.jcc.c.cw.e(cw.java(Compiled Code))
at com.ibm.db2.jcc.c.cw.a(cw.java:1100)
at com.ibm.db2.jcc.b.bd.h(bd.java:138)
at com.ibm.db2.jcc.b.bd.a(bd.java:42)
at com.ibm.db2.jcc.b.r.a(r.java:31)
at com.ibm.db2.jcc.b.bs.g(bs.java:149)
at com.ibm.db2.jcc.c.cw.l(cw.java:1080)
at com.ibm.db2.jcc.c.cw.a(cw.java:1730)
at com.ibm.db2.jcc.c.cw.a(cw.java:408)
at com.ibm.db2.jcc.c.cw.executeQuery(cw.java:392)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecu teQuery(WSJdbcStatement.java:900)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQ uery(WSJdbcStatement.java:445)


This is all on AIX. Any help would be much appreciated. Thanks in advance..

1. DB2 server version
2. DB2 client version
3. Query text

Server:

DB21085I Instance "db8sr300" uses "32" bits and DB2 code release "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
Product is installed at "/usr/opt/db2_08_FP8".

Client:
DB21085I Instance "db8cl001" uses "32" bits and DB2 code release "SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and FixPak "5".
Product is installed at "/usr/opt/db2_08_01".


As for the query, it is a simple select from a view.