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

    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
    Location
    Pune , India
    Posts
    433
    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
    Location
    IL
    Posts
    557
    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 6.1.0.0

Posting Permissions

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