Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: Taking log time to excute the procedure

    Hi All,
    In our environment we running a procedure almost every day
    procedure delete the data from the tables based on ondition
    nearly 5 tables are there in procedure
    before it run 15 min but now it taking nearly one hour

    we did reorg and runstats on the tables still we facing the problem
    based on db2advice the indexes are present in required columns

    Please advise what things need to consider like this situation.

  2. #2
    Join Date
    Jul 2006
    Pune , India
    on data studio you can see how long/cost each stmt is taking within a proc.
    BTW you havnt mentioned your version and os !!
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Nov 2005
    Review what has changed. Performance degradation almost always go side by side with recent changes. It can be an OS level changes as well.
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os

Posting Permissions

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