Skip to Content

Which BW job deletes /BI0/F0SM_ESRLM indexes

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 29, 2013 at 12:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 29, 2013 at 10:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded