Skip to Content
avatar image
Former Member

DB02 Space Statistics missing after ERP Ehp4 SP7 upgrade - Solaris/Oracle

Hi,

I've recently upgraded an ERP 600 system using the SAP Standard procedure

for ERP Ehp4 upgrade. The new SP level is ERP Ehp4 SP7. Since upgrade the

DB02 space statistics are not available even after using the "refresh all datasets" button in the DB02 transaction.

The old DB02OLD transaction works ok and shows the DB space statistics.

Our configuration is based on a distrubuted Solaris SPARC/Oracle system - DB on one host and

CI on another. rsh is working for <sid>adm from the CI to the DB host

to enable the standard DB13 check/update stats jobs to run without error.

Has anyone else had a problem with missing DBACOCKPIT/DB02 after Ehp4 upgrade ?.

Regards,

Brian.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 29, 2011 at 11:56 AM

    Thanks Brian McQuillan your tip has helped us to fix the same on AIX box too..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2010 at 12:25 PM

    Did you check whether SAP note 1261329 applies because you run the db on its own host?

    Kind regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2010 at 12:26 PM

    When you refresh you db02 there will be background job created as REFRESH SPACE STATISTIC:<SID> please check the background job logs.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2010 at 01:47 PM

    any update as to the outcome?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Wow! thank you! This worked for me too in Linux/Oracle.

      My DB02_COLL_PLAN entries were in "i" state so I read note 1002840 (as Brian suggested) and reactivated collector modules as described in step 5. Then I ran RSORACOLR with DEFAULT as value and Voilà!

      All credits to Brian.

      Regards.