STechno

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

Header
Version / Date 4 / 2010-11-16
Priority Recommendations/additional info
Category FAQ
Primary Component SV-BO-DB-IBM Performance Problems IBM Databases
Secondary Components

Summary
Symptom

You are looking for information about DB2's automatic RUNSTATS function in an SAP environment.

Other terms

FAQ, auto-runstats, autonomic features, TCO, zero admin

Solution
https://service.sap.com/sap/support/notes/1502194

(SAP Service marketplace login required)

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