Skip to Content
author's profile photo Former Member
Former Member

rz20 remote database monitoring

Hi girus,

we have to monitor from our Solution Manager a java remote database. We have followed note 1139623, everything works well in transaction DB02 for this remote system except Alert Monitor Tree under Folder Alert . The icons are inactive and are not showing data.

We have already set flag "collect alert data" in transaction DBACOCKPIT.

Any ideas?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on May 15, 2014 at 03:08 PM

    Hi Stefano,

    Can you make sure he database user who is to be entered for the database connection must

    be the relevant schema owner, in other words, SAPR3, SAP<SID>, SAPSR3 or

    SAPDB<SID>?

    Kind regards,

    Roland

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2014 at 03:12 PM

    Hi Stefano,

    What is the version of your SAP Solution Manager? Also check if you need grant permissions for accessing to managed Database host from managing Solution Manager host.

    Regards,

    Fernando,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2014 at 03:30 PM

    Hi Stefano

    In DB02, after selecting for remote system, You may be seeing (Right side of the screen) details for space overview, database, users etc. are empty.

    Perform "Refresh". (After selecting Remote database, if no issue with connectivity from SolMan).

    This trigger a job "REFRESH SPACE STATISTIC:SystemName", once this job finished & you can open DB02 in another screen & you can see all 3 nodes, DB Check, Check Conditions and Alert Monitor will be in active status..

    regards

    Swami

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      Could you please check note:
      1265134 - DBA Cockpit: Connecting a remote database
      1711688 - DBA Cockpit: RZ20 alerts are not generated

      868063 - Database space statistics monitor for Oracle
      1540222 - DBA Cockpit: Monitoring non-ABAP/Java Oracle databases

      If a database is installed on a remote server than the SAPLOCALHOST parameter should be maintained correctly in the agent profile, the value

      for this parameter should be exactly the same as the SAPDBHOST parameter value in the instance profile. If this is correctly done than in the

      transaction AL15 automatically the flag "DB server" will be selected for the related SAPCCMSR agent RFC destination (note 444947).

      1068204 - New monitor template for database monitoring

      Monitoring Standalone DB Server using CCMS Agents

      http://scn.sap.com/community/netweaver-administrator/blog/2013/12/18/monitoring-standalone-db-server-using-ccms-agents

      BR
      T

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2014 at 12:37 PM

    Dear Stefano,

    You should to go to RZ21 and configure CCMS monitoring.

    With best regards,

    Alexander

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 03, 2014 at 08:17 PM

    Hello,

    Can you please look in to note below...

    1458291 - SolMan 7.1 Database Warehouse & Alerting for MSSQL

    This might help you

    Thank you

    Yogesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.