Skip to Content
0

No automatic fixing defective index

Jan 23 at 09:44 AM

30

avatar image

In december I fixed 3 Index manually. After that I turn automatic repair of index on. Now 4 weeks later is one of the tree index defective again. Last week there was a huge load on the db server. I thought he will repair the index. After 7 days the index is already defective. Has anybody an idea how to find the root cause of a defective index ?


Thanks a lot !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Jan 24 at 02:45 AM
0

Hi,

Please check whether the system is hitting issue mentioned by sap note:

2090174 - Possible data corruption when using packed tables

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
Dieter Lorenz Jan 29 at 11:41 AM
0

Hello, thanks for your help. We are using no BW or Unicode compression => UseUnicodeColumnCompression=NO.

Any ideas ? Now the index is fixed manually - running whole 1,5 days.

Share
10 |10000 characters needed characters left characters exceeded