How to activate monitoring attribute of table

[Former Member]

Hi,

>

> Can anybody tell me how to activate the monitoring attribute of table

in DB13.

>

> In DB13 I got this warning

> BR0988W Bitmap index /BI0/9AFTSW_SCQ~07 selected for checking

statistics - please activate the monitoring attribute for table

SAPR3./BI0/9AFTSW_SCQ.

>

> I have activated using the following command

>

> alter table SAPR3.”/BI0/9AFTSW_SCQ” monitoring;

Is there any harm If I activated like this.

>

> I want to know how to let UpdateStat do by itself. Is there any

setting I have to do in se16 -->SDBAC

>

> Please reply your valuable answer.. Thanks in advance

>

>

>Thanks & Regards

>

>Mohd Shafi Ur Rahman

[Former Member]

There is no harm in this for more details follow the note Note 442395 and Note 408527

Cheers,

-Sunil

[Former Member]

Hi Sunil,

Thanks for your reply. I check the Note:408527 but what worries me is this section in the note

Note 3:

-

---

If the MONITORING attribute is used, BR986W warnings referring to fragmented indexes are no longer displayed. As a result, this means of

determining fragmented indexes is no longer available

so what about if that index get fragmented. ?

[Former Member]

follow Note 771929 - FAQ: Index fragmentation

Cheers,

-Sunil