hi guys,

i need a small clarification.
i had created a procedure to "insert" rows into a table and i tried to insert 1million rows it took more than 7 minutes to do that but

i have a java code which "updates" the same table with same number of rows but its taking less than 2 minutes.in the java code i used a prepared statement for updation.

can any one help me by telling that how is this happening

You do not mention which version of db2, what O.S. and how many spindles you have. So is 1.000.000 inserts in 7 minutes good or bad? Dunno. If your table would NOT have any indexes at all you're observation could be odd. So please give us more info about the table and the indexes. Also which columns are updated and are those columns used in 1 or more indexes.

And you procedure, does it fire 1.000.000 time an insert of adding 1 row? Or 1.000 inserts adding 1.000 rows at the time? Any commits in between?

Please answer this questions and then, maybe, we can tell you what is happening.