cancel
Showing results for 
Search instead for 
Did you mean: 

Index in unusable state

Former Member
0 Kudos

Hello,

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

We see this error when any database activities were going on back end, please check with basis team any DB activties shedule at this particular time

0 Kudos

Hello,

By checking the description, I think that the notes below may help to answer your question:

991756 P11:P20:ODS: Dump if only inactive requests are del

515711 Missing indexes after reorganizing PSA tables

410743 PSA: ORA-1502 Index in unusable state

I hope this helps.

Pietro

Former Member
0 Kudos

Hi,

Check DB log space in db02. And check in st22 for the error details. If u still have the problem then you need to check with your basis guy.

Regards,

Rahul.