Thread: DB2 Stored Procedure Performance
06-08-09, 16:05 #1Registered User
- 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.
06-09-09, 01:41 #2Registered User
- 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 packagesRahul Singh
Certified DB2 9 DBA / Application Developer