on 08-11-2014 4:22 PM
Hi experts,
every weekend the job UpdAllStats runs in the SAP systems hosted by us (weekdays just PrepUpdStats+UpdStats). Now we're facing the issue that in one system there are no optimizier statistics for all tables in one special name space - let's call it /XYZ/TABLE1 etc.
We randomly checked tables in that name space via DB20/DB50 and no optimizer statistics could be found. So we randomly checked other tables like MARA, VBAK etc. - all optimizer statistics up to date for those tables.
We even started the statistics refresh via DB20 manually for one of the tables - still no optimizer statistics appearing for this table.
I mean it's an update over all optimizer statistics - I rechecked note 927882 - FAQ: SAP MaxDB UPDATE STATISTICS and some others but couldn't find any reason for these tables being exluded. Especially I don't understand why the manual statistics refresh wouldn't work...
Does anybody have an idea why this could happen?
Thanks for your ideas in advance!
Regards
Marie
Hi again,
well it seems to be more of a visualisation problem I guess.
We figured out that in MaxDB Database Studio you can see the optimizier statistics but not in the SAP system itself.
We'll keep you up to date.
Best
Marie
Edit: it was really just a visualisation problem... DB Studio rhows the right values
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marie,
can you tell us which database and SAP Kernel and DBSLversion you are using.
Which version of BASIS Support Package has been installed in this system.
Regards, Christiane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christiane,
thanks for your reply.
We were unsure if this might happen because the tables are all part of a special namespace but from your answer I conclude that this is no usual behaviour of the MaxDB statistics run.
We'll create a SAP ticket and update this discussion afterwards.
Thanks & regards
Marie
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.