on 07-29-2013 10:26 AM
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.
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.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.