How To Fix RS_DB_DB6020 - DB2 LUW : l'index &1 est superflu et a donc été supprimé.

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_DB_DB6 - DB6-Specific Messages in SAP BW

• Message number: 020

• Message text: DB2 LUW : l'index &1 est superflu et a donc été supprimé.

Quelle est la cause de ce problème?

The standard seconday index &V1& is not needed for this InfoCube and
therefore has been deleted.

Réponse du système

Secondary indexes are created for all key fields of a fact table by
default. However, in this case they are not necessary.
For example, field &V2& in the E-fact table of an InfoCubes which only
contains cumulative key figures is the same for all data records. A
secondary index is not needed for this field and furthermore,
maintaining the index for data manipulation operations such as INSERT,
UPDATE and DELETE in the absence of proper selectivity, is
time-consuming.
If a dimension is selected for multidimensional clustering, the
secondary index is not needed for the corresponding key field. A system-
internal block index is created for the key field. This does not appear
in the ABAP Dictionary.

Comment corriger cette erreur?

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Procédure pour les administrateurs système

Extrait du message d'erreur du système SAP. Copyright SAP SE.