Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2016
    Posts
    5

    Unanswered: Frequent RUNSTAT for query performance

    Hi I have one select query which loses performance on every alternate day and to give it back we do runstat that very table.

    Can I get some suggestion on this why it is required on such a frequent basis, is there any parameter (may be value set is low) creating such problem.

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    111
    Provided Answers: 13
    Hi,

    Read the following article:
    Capturing and accessing section actuals
    Show us both "good" and "bad" access plans with section actuals.
    Regards,
    Mark.

  3. #3
    Join Date
    Aug 2016
    Posts
    5
    Hi,

    I have got the two access plans for your analysis..

    waiting for your opinion



    Thanks!!After_runstats.txtexplain_plan_during_issue.txt

  4. #4
    Join Date
    Jul 2016
    Location
    Germany
    Posts
    32
    Provided Answers: 2

    quick and dirty

    Hi gauavsaxena,

    first thing i noticed was the INDEX IDOC.EVUID
    The Values for sequences are different.
    Is that an coincident, or is there a reorg in you runstats plan ?
    Could you also check if there are autoreorgs in your system,
    wich might be triggered by the runstat values ?

    Good luck
    db2dp

Posting Permissions

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