MISSING_STATISTICS

[Former Member]

Dear Gurus

We have deleted the ACCTIT, ACCTHD, ACCTCR tables and create again, because we was implementing SAP Data Archiving.

But now in the monitoring database show me the following message:

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.ACCTCR

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.ACCTHD

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.ACCTIT

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.ACCTCR~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.ACCTHD~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.ACCTHD~1

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.ACCTIT~0

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.ACCTIT~1

Could you please tell me the action?

Best Regards

[Former Member]

Hi,

In addition to What Satish said.

Alternatively use brtools

3 - Segment management----

---

> 2 - Rebuild indexes.

Regards.

[Former Member]

Hi,

try to build statistics for such objects by running command:

brconnect -u / -c -f stats -t missing

regards,

kaushal

[Former Member]

Hi Kaushal

Can I do this thru DB20, but what New Method and New Sample Size needs to be given ?

Regards,

Aliila

[Former Member]

Hi,

Please login to server & run this command brconnect -u / -c -f stats -t missing.

You can check the log of this command in DB14 tcode. Hope this helps.

Sushil

[Former Member]

Hi,

Run se38 --> RSANAORA --> give the name of the table/index to update the stats.

Regards,