Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: DB2 Stored Procedure Performance

    Hi there. We currently have a java application that is used as our time and attendance application out in our manufacturing facility. This application calls a DB2 stored procedure that updates one table whenever an employee clocks in or out. All of a sudden, the performance has been awful. Basically the issue occurs when we have all employees (which is about 100) clocking out at the end of the day at the same time. (We have 12 different time clocks). Normally when they scan their badge the stored procedure is executed in about 3 seconds. Now it is taking about 15-30 seconds per transaction. I'm really not even sure how to troubleshoot this issue. Where should I be looking? Is there some sort of query analyzer I can use to see what's going on?
    Thanks for any help you can give me.

  2. #2
    Join Date
    Jul 2006
    Pune , India
    what version are you on?
    Are runstats recent ?
    Index scan happening ?
    You can have a look of the access paln for the associated packages
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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