Skip to Content
avatar image
Former Member

Database size history not getting updated in DB02

Hi Experts,

This is really a baffling problem for newbie like me

In DB02 for DEV and QAS i checked, database size history is shown till date 12 th march 2009

but for PRD system it is showing till date 22nd jan 2009. After that no data is recorded

the systems are SAP ECC 6.0 MS SQL Server database Windows NT platform.

SAP_BASIS level is 14

so i found this note 1144935 which says RSMSSDBSZHIST is used to collect space history.So this program is working fine in DEV and QAS but not in PRD

This program uses data from MONI data. My wild guess there some problem with moni data of PRD system

Some questions

1) Does DB02 transaction gets its data from SAP_COLLECTOR_FOR_PERF_MONITOR(scheduled daily on system)??

2) How do i check MONI data values??

Also some alterations should be done in above program according to the note after application sp13 but none have been performed in 3 systems still it is working fine for DEV and QAS but not for PRD.

I have reached dead end

Any suggestions

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 12, 2009 at 09:02 AM

    Hi Joshi,

    Run the program rsdb_tdb in sa38 and check whether database statistics have been updated or not.

    Regards,

    Kalyan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hai,

      I guess there is some Time zone mismatch in your system, please check it.

      Also go through the SAP Notes 73945 and 48598.

      Regards,

      Yoganand.V