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.