We have a web based application with a Db2 back-end. We have started experining intermittent response-time. The same insert insert transactions that take few seconds they can take 15minutes (just inserting 100 rows). We had made all kind of adjustments to different DB2 parameters, but we still get spikes few times a day. Any idea what could be the cause?

Check the network reponse times.

If possible, run the insert sqls directly in the DB server and see the timings comapre to the execution from web container.

Harikumar

What changes have you made?

have you checked locks on the database ? what is the lock timeout?

Try setting up sql and transaction event monitors to identify where the problem is - inside database or outside.