Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Index in unusable state


We load data into an ODS every day at 3.00 am from monday till friday. Everything always goes fine, except for the monday load. Then a shortdump occurs, and ST22 says DBIF_RSQL_SQL_ERROR. SM21 says the index is in unusable state.

The DBA always fixes it, but it is unclear when and how the index is becoming unusable.

The DBA checks the indexes on saturday and then everything is fine.

How can I check what happens with this index?

Thanks in advance.

Not what you were looking for? View more on this topic or Ask a question