STechno

Note 1502194 - DB6: Automatic Statistics Collection (Automatic RUNSTATS)

Solution
https://service.sap.com/sap/support/notes/1502194 (SAP Service marketplace login required)

Key words :    , statistics collection, automatic statistics, automatic runstats,   automatic,   tid ,   level,   substr, tid   , eventpid   , level eventpid , statistics profile,   object, bytessapecc   , automatic table, stats object,   eduname, index stats, db2ecp   , 0instance db2ecp , on   , table maintenance, online maintenance, statistics cache, 63   ,   63 ,   explain, db2acd 0instance,   *local, runstats probe, 000appid   , db2aps   , runstats utility, automatic maintenance, off   , maintenance window, database partition, database configuration, database manager, statement compilation, asynchronous check, asynchronous collection, startobject   , enable automatic,   soscimpact , optimizer sqlno,   sapecceduid ,   appid, sapecceduid   , eduname db2agent, sqlno runstats, soscimpact   , fabrication probe,   14479552 , 29814   ,   29814 , 1151   , runstats command, partition group, statistics profiling, maintenance activities,   1151 , db2acd 0function, 14479552   , ecpapphdl   ,   1177 , 1177   , eduname db2acd, *local db2ecp, successobject   , db   , collect statistics,   ecpapphdl , database snapshot, following example, atmtable runstats, maintenance atmtable, runstats   , maint on , maintenance   , synchronous statistics, catalog cache,   31356 , 000   ,   11698366 , db2sysc 0instance, 31356   , 11698366   ,   db , takes place, database crashes, configuration parameters, following command, volatile tables, their statistics, diagpath events, information about, configuration parameter, partitioned database, database statistics,   nonedata, optimization guideline, runstats runstats, events directory, name   , maintenance database,