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

Related Notes
1425488DB6: Performance problems with volatile tables
1381591DB6: Database crashes when fabricating statistics
1309705DB6: Log space not released by statistics update
1160813DB6: Accessing a table returns SQL0901N
966970DB6: New tables remain VOLATILE for AutoRunstats
533589DB6: SQL2314W Some statistics are in an inconsistent state