How To Fix RSCV542 - INFORMIX: Datenbank-Statistik für Tab. &1 veraltet (Schwellenwert: &2 %)

SAP Error Message - Details

• Message type: E = Error

• Message class: RSCV - Analysis of BW objects (InfoCubes...)

• Message number: 542

• Message text: INFORMIX: Datenbank-Statistik für Tab. &1 veraltet (Schwellenwert: &2 %)

Was verursacht dieses Problem?

The database statistics for table &v1& are obsolete. With a chosen
threshold of &v2& %, this means that at least &v2& % of the data in the
table in question has been added, or deleted, and no 'update
statistics' has been carried out since. The threshold is defined on the
tabstrip <LS>Performance</> of an Infocube (InfoCube -> Maintain
content, or InfoCube -> Performance).
No correct statistical information is in the database optimizer. This
can lead to bad run schedules and thereby to poor performance.

Wie behebe ich diesen Fehler?

Build up current database statistics for table &v1&. For this, use a
repair routine, that is assigned to this analysis routine (function
<PF>Remove error </>in the transaction <ZH>RSRV</>).

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE