Db2 Connect - JDBC batch update question

Mehdi Fakhar

Db2 Connect - JDBC batch update question
Application is using JDBC 2.0's feature of Batch processing to insert
multiple rows to DB2 V 7.2 on OS/390. This is done to reduce the network
traffic for many inser/uodates. This seems to work except for large volume
of data. We have identified that based on row length and number of inserts,
100,000 bytes sent across the network gets inserted into DB2 tables
properly, but 1 MB of data sent across the network does not perform the
inserts. The developer indicates application gets no error message. THre is
also no messages in DB2 Log.
Since there are no limits on DB2 (based on my knowledge) as the number of
bytes being inserted, is there a limit on DB2 Connect? We use Db2 Connect
7.2 fixpack 10A

Any help is appreciated.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Abhijit Sinha

Re: Db2 Connect - JDBC batch update question
(in response to Mehdi Fakhar)
It could be because of the limit on the length of the SQL statement (65535
bytes) being used in the addBatch() or executeBatch() methods. See link
below:

http://www.developer.ibm.com/tech/faq/individual/0,,2:78894,00.html

Abhijit


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Mehdi Fakhar
Sent: Monday, January 19, 2004 2:43 PM
To: [login to unmask email]
Subject: Db2 Connect - JDBC batch update question


Application is using JDBC 2.0's feature of Batch processing to insert
multiple rows to DB2 V 7.2 on OS/390. This is done to reduce the network
traffic for many inser/uodates. This seems to work except for large volume
of data. We have identified that based on row length and number of inserts,
100,000 bytes sent across the network gets inserted into DB2 tables
properly, but 1 MB of data sent across the network does not perform the
inserts. The developer indicates application gets no error message. THre is
also no messages in DB2 Log.
Since there are no limits on DB2 (based on my knowledge) as the number of
bytes being inserted, is there a limit on DB2 Connect? We use Db2 Connect
7.2 fixpack 10A

Any help is appreciated.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm