on 05-11-2013 5:34 AM
Dear All,
How I rectify this warning:
BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3./BIC/0CTR000016
Thanks
MS
Dear MS,
It is common to have unusuable indexes in BW as indexes are dropped and
recreated during the loading processes, if indexes are not created
locally afterwards they can become unusable. The warnings from the
checkdb show that the above indexes are missing. Please check in
DB02 if the indexes exist. Indexes for BW should never be created via
SE14 or DB02. Please refer to oss notes #1455000 and #515711 for
solution steps.
regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
im not sure you should correct all warning you find but a new index will not harm your system
Go to se14, specify the table then at the following screen click index and create a Z01 for example
Let me know if you need further details
a
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.