Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Problem using s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 8840 of 9055
Post > Topic >>

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

by milivoj.fradelic@[EMAIL PROTECTED] Apr 29, 2008 at 11:29 AM

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]T2zosPreparedStatement.
readExecuteInternal:nativeExecute:5665:Abend occurred in DB2, Driver
successfully retry,
SQLCODE = -4499, SQLSTATE = null,
error tokens = signal:18 acode:0004E000,reas:00E20004,con:
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
 




 1 Posts in Topic:
Problem using sqlj with type 2 universal driver - Db2, z/Os, v8.
milivoj.fradelic@[EMAIL P  2008-04-29 11:29:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 16:31:59 CDT 2008.