SAP Notes

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

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