cancel
Showing results for 
Search instead for 
Did you mean: 

Which BW job deletes /BI0/F0SM_ESRLM indexes

benoit-schmid
Contributor
0 Kudos

Hello,

In our SolMan 7.1, there is a frequent job that deletes./BI0/F0SM_ESRLM:

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table - table_stats) SAPSR3./BI0/F0SM_ESRLM
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table partition) SAPSR3./BI0/F0SM_ESRLM./BI0/F0SM_ESRLM0000000082
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~01./BI0/F0SM_ESRLM0000000082
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~02./BI0/F0SM_ESRLM0000000082
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~04./BI0/F0SM_ESRLM0000000082
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~05./BI0/F0SM_ESRLM0000000082
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~06./BI0/F0SM_ESRLM0000000082

Would you know how I can find which job it is?

Thanks in advance for your answers.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Benoit,

For these temporary BI related indexes/tables you should create the statistics along with the index or table creation we have the same problem in my company the BW/BI support staff should do this.

As your statistics usually run in early morning hours outside of office hours to avoid locks caused by your main statistics run. This would be scheduled as example:

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

The job you are looking for if it deletes and recreates statistics is BW job usually but on solman system.

http://wiki.sdn.sap.com/wiki/display/BI/BW+temporary+database+objects

You  could exclude these in your initSID.sap file to exclude these from being listed in missing statistics by changing the following:

check_exclude = (SAPSR3./BIC* , SAPSR3./BI0*)

I am not sure which job and why these would be running on Solman though must be some kind of LMDB job.

/BI0/F0SM_ESRLM - Solution-Manager-LMDB

Kind Regards,

Johan

Answers (1)

Answers (1)

JPReyes
Active Contributor
0 Kudos

there is a frequent job that deletes./BI0/F0SM_ESRLM:

What above means is that that table is missing stats, you can run your optimizer stats on DB13

Regards, Juan

Former Member
0 Kudos

Hi Benoit,

               This implies that you statistics are not updated for this table in question , please check whether you database update statistics job is running at regular intervals in DB13.

Thanks and Regards,

Kunal Gahlot

benoit-schmid
Contributor
0 Kudos

Hello,

If I run the stats at 23h.

The check at 23h30 complains for these missing stats.

This is why I would like to find out which job keeps deleting these indexes.

Regards,