Professional Web Applications Themes

Sometimes SQLCODE: -805 appears - IBM DB2

Hi Everyone, I've got a db2 problem. My Java program connects to a IBM Db2 8.1.3 database. There's only 1 active connection to the database via JDBC type 4 driver. A prepared statement is used to insert 100 to 1000 records in one sequence. Most of the time everything works great, but sometimes an error occurs, the -805 error. The error description says that a package is corrupt or gone, in this case SYSLH205 (but it's always different). I don't know what it is or why it appears. I only use an insert statement. I never throwed anything away. It ...

  1. #1

    Default Sometimes SQLCODE: -805 appears

    Hi Everyone,

    I've got a db2 problem.
    My Java program connects to a IBM Db2 8.1.3 database.

    There's only 1 active connection to the database via JDBC type 4 driver.
    A prepared statement is used to insert 100 to 1000 records in one sequence.
    Most of the time everything works great, but sometimes an error occurs,
    the -805 error.

    The error description says that a package is corrupt or gone, in this
    case SYSLH205 (but it's always different). I don't know what it is or
    why it appears. I only use an insert statement. I never throwed anything
    away.
    It occurs on the production and testdatabase. So I don't think that it
    has nothing to do with the installation of the database. Or that I've to
    bind a package.

    Has anybody a explanation why it happens? And better how it can be
    solved (with a workarround is als good).

    Thanx in advance,
    Marcel Rokers

    The code:

    ....
    SQLins =
    "INSERT INTO "
    + Constants.DB2SCHEMA
    + ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";

    insertStmt = db2.getConnection().prepareStatement(SQLins);

    while (...) {
    ...
    insertStmt.setInt(1, measureID);
    insertStmt.setTimestamp(2, time);
    insertStmt.setFloat(3, value);
    insertStmt.setInt(4, shiftID);
    insertStmt.executeUpdate();
    ...
    }
    insertStmt.close();
    ....

    The error message that occurs:

    SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
    NULLID.SYSLH205 0X5359534C564C3031
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
    51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
    at com.ibm.db2.jcc.a.co.e(co.java:1361)
    at com.ibm.db2.jcc.b.bd.o(bd.java:545)
    at com.ibm.db2.jcc.b.bd.g(bd.java:124)
    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.bp.g(bp.java:103)
    at com.ibm.db2.jcc.a.co.g(co.java:968)
    at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
    at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
    at com.ibm.db2.jcc.a.cp.K(cp.java:316)
    at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
    at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
    at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
    at com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
    at
    com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.java:113)
    at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)

    Marcel Guest

  2. #2

    Default Re: Sometimes SQLCODE: -805 appears

    Mixed client versions (fix levels)?
    "Marcel" <com> wrote in message
    news:3f82b9da$0$28892$euronet.nl... 
    sequence. 
    com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98) 
    com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
    a:113) 


    Mark Guest

  3. #3

    Default Re: Sometimes SQLCODE: -805 appears

    Hello Mark,

    That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
    productiondatabase is 8.1.0 + 8.1.2 client.

    I'll try it right away and come back with the answer.

    Thanx for your help.
    Marcel

    Mark Yudkin wrote: 
    >
    > sequence.

    >
    > com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)

    >
    > com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
    > a:113)

    >
    >
    >[/ref]

    Marcel Guest

  4. #4

    Default Re: Sometimes SQLCODE: -805 appears

    Yes, that'll cause the problem.

    OTOH, package versioning in DB2 V8 was supposed to finally get rid of these
    issues. You may like to open a PMR.

    "Marcel" <com> wrote in message
    news:3f8a72ce$0$64179$euronet.nl... 
    > >
    > > sequence.
    > > 
    > >
    > > com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
    > > 
    > >
    > >[/ref][/ref]
    com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav 
    > >
    > >
    > >[/ref]
    >[/ref]


    Mark Guest

  5. #5

    Default Re: Sometimes SQLCODE: -805 appears

    Mark,

    This is the solution. The -805 doesn't occur anymore in production and
    in the testenvironment.

    In test I now use 8.1.3 + 8.1.3 JDBC client.
    In production I now use 8.1.0 + 8.1.0 JDBC client.

    But now I can't have the complete program packaged anymore inluding the
    JDBC driver. But you can't have it all......

    Thanx a lot,
    this problem has cost me serious headtroubles.
    Marcel

    PS. What means a PMR (a bugreport I asume?)???

    Mark Yudkin wrote:
     [/ref]
    > com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
    > [/ref]
    >
    >[/ref]

    Marcel Guest

  6. Moderated Post

    Default Re: Sometimes SQLCODE: -805 appears

    Removed by Administrator
    Marcel Guest
    Moderated Post

  7. #7

    Default Re: Sometimes SQLCODE: -805 appears

    Hello,

    i have the same error happend after i run our application for a while.
    my server is db2 v8.1 windows 64 bit with fix pack3. it asks for
    package SYSLH203.i don't think there is one exist. i have tried to do
    db2jdbcbind for size 60, the maxappls is 60. what else i can do to fix
    this problem? i don't know what is jdbc client. our application just
    use db2jcc driver to connect to server database. is this problem
    related to client? i am using db2jcc jar come from the fix pack.
    please help !!!
    xixi Guest

  8. #8

    Default Re: Sometimes SQLCODE: -805 appears

    If a BIND doesn't help (i.e. SYSLH203 doesn't exist), you'll have to open a
    PMR.
    "xixi" <com> wrote in message
    news:google.com... 


    Mark Guest

  9. #9

    Default Re: Sometimes SQLCODE: -805 appears

    sorry, we are just have DB2 trial version. is there we still can
    submit the PMR? (what does it represent?)

    thanks
    xixi Guest

  10. #10

    Default Re: Sometimes SQLCODE: -805 appears

    You need a valid service and support contract to submit a problem report
    (PMR). If it is definitely a DB2 defect, and you can submit a test case
    which we can easily reproduce, we can look at getting this officially
    recognized as a an APAR (Authorized Program ysis Report - fancy word
    for defect). But, it will be very hard to provide you with fixes or
    problem ysis until you purchase the support contract.

    xixi wrote:
     

    Blair Guest

  11. Moderated Post

    Default Re: Sometimes SQLCODE: -805 appears

    Removed by Administrator
    Marcel Guest
    Moderated Post

Similar Threads

  1. How can I obtain SQLCODE in SPL ?
    By Marek in forum Informix
    Replies: 14
    Last Post: November 28th, 04:37 PM
  2. #25206 [Fbk->Csd]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By jkshin at naver dot com in forum PHP Development
    Replies: 0
    Last Post: August 22nd, 11:29 PM
  3. #25206 [Opn->Fbk]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 22nd, 01:38 PM
  4. #23169 [Opn->Fbk]: SQLCODE=-1802 Connection name in use.
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: July 13th, 04:52 AM
  5. SQLCODE vs. ORA-nnnnn msgs
    By Ed Stevens in forum Oracle Server
    Replies: 4
    Last Post: December 9th, 02:26 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139