var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 7.2.8 need statistics/benchmark
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 ?
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.
Visit the new-look IDUG Website
, register to gain access to the excellent content.
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.