Db2 On Premise and Cloud

 View Only
Expand all | Collapse all

DMC - Why RUNSTATS performed on IBM_RTMON.ACTIVITY% tables?

  • 1.  DMC - Why RUNSTATS performed on IBM_RTMON.ACTIVITY% tables?

    Posted 28 days ago
      |   view attached
    Hello DMC-Team,

    in the utilities event monitor screen I frequently see RUNSTATS utility executions in the monitored database on the IBM_RTMON.ACTIVITY% tables triggered by the DMC application UC_MYMON (see attached file for details). 

    Why does DMC collect statistics on tables that are deleted a few seconds later anyhow?

    Thanks for your feedback in advance.

    Best regards - Matthias

    ------------------------------
    Matthias Gärtner-Schür
    DBA
    ------------------------------

    Attachment(s)



  • 2.  RE: DMC - Why RUNSTATS performed on IBM_RTMON.ACTIVITY% tables?

    Posted 10 days ago
    Edited by Yuan Gao 10 days ago
    Hi Matthias,

    Thank you for contacting us. DMC joins three event monitor tables (IBM_RTMON.ACTIVITY%, IBM_RTMON.ACTIVITY_STMT% and IBM_RTMON.ACTIVITY_METRICS%) to retrieve all the events and persist them into the repository. As we want to ensure the Db2 optimizer choose the best access plan to execute the join query, these RUNSTATS commands are executed and statistics information is gathered for the optimizer before the query execution, as suggested by Db2 SME. 

    If you have any concern or requirement, please let us know.

    Best regards,
    ------------------
    Robbie
    IBM Db2 Data Management Console Team
    ------------------



    ------------------------------
    Yuan Gao
    ------------------------------