How To Fix RSCV630 - Die Faktentabelle für Infocube &1 enthält &2 zusätzliche Indizes

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 630

• Message text: Die Faktentabelle für Infocube &1 enthält &2 zusätzliche Indizes

Was verursacht dieses Problem?

Specific indexes are created as standard by the BW system for the fact
tables that are normally sufficient to perform well. Each additionally
created index increases the amount of index maintenance when changing
data in the InfoCube.
The option to delete secondary indexes before loading data and to
rebuild after loading only concerns the standard indexes. Additionally
created indexes remain and can therefore influence the loading
performance negatively.
Also, if the secondary indexes are not deleted before loading, each
additional index increases the amount of index maintenance and, along
with it, reduces performance when loading data.
The routines for repairing secondary indexes (transaction RSRV)
exclusively concerns the standard indexes. Additionally created indexes
have to be checked manually and possibly repaired.

Systemantwort

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Wie behebe ich diesen Fehler?

Check each additional index to see if loss of performance when loading
data outweighs its use, which is brought about by executing queries. If
not, you need to delete it.
Since the index schema for fact tables from DB2/400 was changed, these
additional indexes can also be obsolete indexes that still come from
the old index concept. In this case, their names end in three-digit
numbers between +500 and +900 or in two-digit numbers between +50 and
+90.
With the report SAP_INFOCUBE_INDEXES_CHG_DB4, the indexes from the fact
tables can be adjusted to the new index schema. For more information
about this, see SAP Note 451808.
You can read units about the index schema for the BW fact tables from
DB2/400 in SAP Note 407528.

Vorgehensweise für Systemadministratoren

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE