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

Component : Performance Problems IBM Databases -

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, table maintenance, online maintenance, statistics cache, 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, 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, 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