How To Fix RS_DB_DB6020 - DB2 LUW: El índice &1 no es necesario y se ha borrado

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: El índice &1 no es necesario y se ha borrado

¿Qué causa este problema?

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

Respuesta del sistema

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.

¿Cómo arreglar este error?

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

Procedimiento para Administradoras de Sistemas

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.