It's all about the answers!

Ask a question

runstats frequency on data warehouse DB

Joao Ramires (34619) | asked Feb 16 '17, 10:08 a.m.

Hi all,
my db2 admin is asking why a runstats is run against ccm data warehouse db (DB2 is used, in this case). He says he's not doing that runstats and it's some ccm Server / Advance Properties / property that force the runstats each hour.
Can someone have an idea about what to check?

One answer

permanent link
Kevin Ramer (4.5k8185200) | answered Feb 16 '17, 11:52 a.m.

I have seen runstats active on dw database during etl jobs.  It is also plausible that the database itself is configured to evaluate runstats/reorg

db2 get db cfg for database XXXX

Part of that output is [ these are not default settings ]

Automatic maintenance                      (AUTO_MAINT) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
       Real-time statistics            (AUTO_STMT_STATS) = OFF
       Statistical views              (AUTO_STATS_VIEWS) = OFF
       Automatic sampling                (AUTO_SAMPLING) = OFF
     Automatic reorganization               (AUTO_REORG) = ON

In addition there is the possibility of configuring these activities to be constrained to certain days/times, but if memory serves, the default is any day/any time.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.