How To Fix RSCV542 - INFORMIX: Database statistics for table &1 are obsolete (Threshold: &2 %)

RSCV542 - Overview

• Message type: E = Error

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

• Message number: 542

• Message text: INFORMIX: Database statistics for table &1 are obsolete (Threshold: &2 %)

What causes this issue?

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.

How to fix this error?

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</>).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSCV542 - INFORMIX: Database statistics for table &1 are obsolete (Threshold: &2 %) ?

  The SAP error message RSCV542 indicates that the database statistics for a specific table in an Informix database are considered obsolete. This typically happens when the data in the table has changed significantly, and the statistics that help the database optimizer make decisions about query execution plans are no longer accurate.
  
  Cause:
  The primary cause of this error is that the statistics for the specified table have not been updated after a significant number of changes (inserts, updates, deletes) have been made to the data. The threshold percentage (&2) indicates the level of change that triggers the need for updated statistics.
  
  Solution:
  To resolve this issue, you need to update the database statistics for the affected table. Here are the steps to do this:
  
  
  Identify the Table: The error message will specify the table name (&1) that has obsolete statistics.
  
  
  Update Statistics: You can update the statistics for the table using the following SQL command in