Warnings in CheckDB in ( BW Production Server )

[Former Member]

Hello Guru's

We are getting this warnings in our checkDB jobs in Darabase planning calendar

Attaching the log for your reference

BR0969I Checking database administration...

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BIC/F100085

Please guide me the rectification

Thanks & Regards

Shishir

[Former Member · Accepted solution]

Hi,

What you need to do here is goto tcode se14-->give table name that is /BIC/F100085 & then click on edit. Here see the name of idexes for that table & then click on Activate & Adjust with database button. This sould solve your problem

Please see below thread for below details.

Thanks,

Sushil

[Former Member]

Thanks

[Former Member]

Dear Shishir,

Update Statistics or create manually index by se11.

SurendraJain

[abhimanyu_pandey]

Hi..

I think one index is missing, so you need to recreate it.

Just go to db02 and click missing index tab, you should get a red line indicating missing index. select that line and choose create index in back ground.

Ohter wise you can use tcode "se12" but it need more expert level.

Hope it will resolve yr problem,

Regards,

Abhimanyu