cancel
Showing results for 
Search instead for 
Did you mean: 

No update of the Optimizer statistics in the last 3 months

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Balaram,

Refer SAP Note 927882 - FAQ: SAP MaxDB Update Statistics

Additionally for checking and executing statistics refer blog

http://scn.sap.com/community/maxdb/blog/2010/05/27/maxdb-optimizer-statistics-handling-without-netwe...

http://wiki.scn.sap.com/wiki/display/MaxDB/How+to+execute+Update+Statistics

Hope this helps.

Regards,

Deepak Kori

Answers (0)