How To Fix RS_DB_DB6020 - DB2/LUW: Index &1 deleted as not required

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: Index &1 deleted as not required

What causes this issue?

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

System Response

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.

How to fix this error?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RS_DB_DB6020 - DB2/LUW: Index &1 deleted as not required ?

  The SAP error message RS_DB_DB6020 indicates that an index in a DB2/LUW (Linux/Unix/Windows) database has been deleted because it was deemed unnecessary. This typically occurs during database operations where the system evaluates the indexes and determines that a particular index is not being used or is redundant.
  
  Cause:
  
  Unused Index: The index may not be used by any queries or operations, leading the database optimizer to consider it unnecessary.
  Redundant Index: There may be another index that serves the same purpose, making the deleted index redundant.
  Database Maintenance: During routine maintenance or optimization processes, the database may automatically remove indexes that are not beneficial for performance.
  
  
  Solution:
  
  
  Review Index Usage: Check the usage statistics of the indexes in your database. You can use DB2 commands to analyze which indexes are being used and which are not.
  
  Use the LIST INDEXES command to see the indexes on a table.
  Use the EXPLAIN command to analyze query plans and see