BR0970W: MISSING_STATISTICS

Sympton

Normally, the issue is occured in SAP BW system with Oracle database. You can check the issue from DB16: Database Check – Overview of Messages. BR0970W, Database administration alert – level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3./xxxx/xxxxx

Solution

Method 1
1. Run the UPDATESTAT before CHECKDB in transaction code DB13

Method 2

1. Login to the OS level as SIDadm and change mode to BRTOOLS. Execute below command

> brconnect -c -u / -f stats -t <TABLE or INDEX>

or

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

2. Execute the CHECKDB again.

Method 3
1. Update you BRTOOLS to the latest patch

You May Also Like

Leave a Reply?