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

SAP Error Message - Details

• 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 Informix:
  UPDATE STATISTICS FOR TABLE <table_name>;
  Replace <table_name> with the actual name of the table indicated in the error message.
  
  
  Verify Update: After running the command, you can verify that the statistics have been updated by checking the system catalog or using specific queries to confirm the statistics are current.
  
  
  Schedule Regular Updates: To prevent this issue from recurring, consider scheduling regular updates of statistics, especially for tables that undergo frequent changes.
  
  
  Related Information:
  
  Database Performance: Keeping statistics up to date is crucial for the performance of the database, as the query optimizer relies on accurate statistics to generate efficient execution plans.
  Informix Documentation: Refer to the Informix documentation for more details on managing database statistics and understanding the implications of outdated statistics.
  SAP Notes: Check SAP Notes for any specific recommendations or patches related to this error message, as there may be updates or best practices provided by SAP.
  
  By following these steps, you should be able to resolve the RSCV542 error and ensure that your database statistics are current, leading to improved query performance.