3631480 - DB6: VOLATILE tables reported in the EWA report

Symptom

The EWA report contains the following information

15.7 Volatile Tables
We have found tables that should be set to VOLATILE but are currently receiving statistics on <SID>.
For performance reasons, some tables should not receive statistics from RUNSTATS, and should be set as VOLATILE.
SAP recommends an in-depth database analysis e.g. via a Technical Performance Optimization Service (TPO) to evaluate the impact on the system and to give specific recommendations.

Environment

Db2 LUW IBM
SAP Early-watch Reporting

Product

SAP ERP 6.0

Keywords

Runstats, Reorg, check, optimizer, optimiser, SQL, performance, query, statistics, DBAcockpit, SAP, flag, set, EWA, Solution Manager, Solman, run, report, reporting, collect, DML activity, distribution, schedule, buffer, temporary, load, frequent, fresh, stale,

, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , SV-SMG-SER-EWA , EarlyWatch Alert , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.