Problem using sqlj with type 2 universal driver - Db2, z/Os, v8.2

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • milivoj.fradelic@fina.hr

    Problem using sqlj with type 2 universal driver - Db2, z/Os, v8.2

    Hi!

    I have following actions:

    for each file do
    begin transaction
    parse file to temp table
    insert into table from temp table --insert into main select * from
    temp
    commit
    end

    Each file has about 10.000 records. When I reached about 900.000
    records this error occurred:

    IBM/DB2][T2zos/2.10.113]T2zosPreparedSt atement.
    readExecuteInte rnal:nativeExec ute:5665:Abend occurred in DB2, Driver
    successfully retry,
    SQLCODE = -4499, SQLSTATE = null,
    error tokens = signal:18 acode:0004E000, reas:00E20004,c on:
    277FD2A0,tcb:
    277FD430

    This happened when I use type 2 driver but when I use type 4
    everything work fine.

    Any idea ? Bind is done using type 4. Is it ok ?

    Database is DB2 UDB 8.2 on z/OS, application is Java batch started
    with BpxBatch (Unix shell...)

    Thanks in advance,
    Milivoj
Working...