on 05-18-2009 12:50 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.