DB02 Statistics not Changing

[Former Member]

Hi,

DB space statistics is not changing - Last analysis: 29.07.2011 05:23:38. (Today is 07.09.2011).

When checking in DB02 the Used space & free space is showing an old value..What can be the reason & how I resolve??

[Former Member]

Hi,

Have you tried this note. 1508792

In case this doesnt work then please have a look into the note 1002840 and the table DB02_COLL_LOG.I think the entries need to be in active status.Thanks.

[ashish_vikas]

Hi,

you should work with SAP Note 1002840.

Note 1002840 - No data or obsolete data in DB Space Statistic monitor

thanks

ashish

[Former Member]

Checked the note but could not find anything.Still with no solution.

[sunny_pahuja2]

Hi,

What is the frequency and status of job SAP_COLLECTOR_FOR_PERFMONITOR ?

Thanks

Sunny

[ashish_vikas]

and what happens when you click on refresh button in DB02 ? does your Refresh space statistic default job runs ?

in DB02OLD also u can refresh one time manually by using Refresh > DB Checks & update histories.

[Former Member]

Ashish thanks..In DB02OLD the statistics is showing fine..But in DB02 I am not getting the updated statistics.

[Former Member]

HI,

Have you checked this note : 868063 and please maintain the tcoll table as per note in smp.You havent told me as to how the entries are there in DB02_COLL_PLAN table.

[Former Member]

Most probably stats job is not running successfully. Check and confirm all the basis jobs. Thanks