Results 1 to 3 of 3

Thread: Slow Inserts

  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Unanswered: Slow Inserts

    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?

  2. #2
    Join Date
    Mar 2006
    Posts
    104
    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

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •