Hi,

I have a UDB DB2 7.2.8 on a Xeon 2.4 GHz/3G ram MS Win 2003 and i try to do mass insert from a java client using jdbc. Each INSERT is about 60kb.

What is the number of INSERT can i expect to have with that kind of configuration? I run the wizard to configure the db to turn it to mass insert.

Now, i have about 100 insert/sec when i commit each 1000 INSERT.

In fact, i have to INSERT about 100.000 rows in less than 10 min.

What can i do to increase the number of insert ?

Thanks

JMi

This is what I recommend

1. Turn append on for table.

alter table <table_name> append on.

2. If your table is created with not logged

then turn it on

alter table <table_name> activate not logged initially.

Please make a backup of the table after mass insert.

3. If possible take lock at the table level

alter table <table_name> locktype table.

drop any indexes and rebuilt after the mass insert.

If possible use load utillity.

Parameter tuning also needs to be tuned.

regards

Mujeeb

This developerworks article should help

http://www-128.ibm.com/developerwork...m-0403wilkins/

Finally found a solution.

I put the stored procedure to the garbage and i used PreparedStatement, it works quicker now.

Now, i have 375 row/sec. (Windows 2003, Xeon bi-pro 3 GHz and 3G of ram), row of 70 bytes.

JMi