on 09-17-2013 12:27 PM
Hello Friends,
We are getting an alert in Live Cache alert monitor :No update of the Optimizer statistics in the last 3 months, in APO system.
APO system database on DB2 and Live cache on SAP DB. I have no idea on SAP DB Optimizer statistics.
Suppose, if No update of the Optimizer statistics running in the system , any drawbacks
i have found below link related to this ,, but i am not 100% sure how to proceed
http://help.sap.com/saphelp_nw04/helpdata/en/56/e84afcac4c3d469719039d72528ff0/content.htm
any help?
regards,
Balaram
Hi Balaram,
Refer SAP Note 927882 - FAQ: SAP MaxDB Update Statistics
Additionally for checking and executing statistics refer blog
http://wiki.scn.sap.com/wiki/display/MaxDB/How+to+execute+Update+Statistics
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.