Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Unanswered: I get SQLSTATE: 51002 when I switched to DB2 universal driver

    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..

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    1. DB2 server version
    2. DB2 client version
    3. Query text

  3. #3
    Join Date
    Sep 2005
    Posts
    2

    Client/Server/Query

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •