Daily statistics is not showing

[Former Member]

Hi

when i am going in Db02 => History => Table and Index => statistics => Daily

Daily statistics is not showing.

Only weekly and monthly statistics is showing.

Pleas advise

Thanks in advance..

[Former Member]

Hi,

DB02 will only show data that has been collected before . Click the refresh button in DB02. In the long run you should run a daily dbcheck job, for examply by means of transaction DB13.

You also need to check that the daily housekeeping jobs are running.

Thanks

Ruchika

[Former Member]

Hi

all jobs is running ...but it shows only weekely statistics not daily in Db02

Thanks

shail

[Former Member]

SAP_COLLECTOR_FOR_PERFMONITOR is responsible to update the stats records from moni , which you can see as history data in DB02 tcode.

Check this job is running from client 000 and check TCOLL table for the entries with Note 966309 - Contents of table TCOLL in SAP_BASIS 700.

Edited by: Vijay Kottappan on Sep 2, 2009 1:00 AM

[Former Member]

Various checks you could perform

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

[Former Member]

Hi..

Check the SAPOSCOL is running or not??

Regards

Gangadhar