Technical monitoring of MaxDB database on Windows.

At first register the MaxDB SID into Solution Manager System with transaction DB59

Execute transaction DB59:

1.JPG

  Click on integrate database and enter the required details as below:

  Select MaxDB and then continue.

2.JPG

   Enter the details of server, SID of MaxDB instance along with the credentials of database users.

3.JPG

  Once details are entered save it.

4.JPG

5.JPG

   After saving click on to DBA Cockpit now:

17.JPG

  After successfully adding database details, properties of database are now available in the dbacockpit of Solution Manager.

7.JPG

Next step is to register MaxDB SID to Solution Manager LMDB.  Since there is no direct way to connect or register MaxDB SID to Solution Manager System,
there are commands which need to be executed in order to do this.

Make sure that the host agent patch level is greater than 143.

There are few commands that need to be executed for registering MaxDB SID ‘s to Solution Manager system.

  1. saphostctrl.exe -host <hostname> -user sapadm <password> -dbname <SID> -dbtype ada -function GetDatabaseProperties -dbuser <user>-dbpass
    <password>

8.JPG

   2.  saphostctrl.exe -host <hostname> -user sapadm <password>-function ExecuteOperation -name SetupMaxDBCredentials SID=<SID>

        DatabaseToolsPath=C:\sapdb\programs\bin USERNAME=<user> PASSWORD=<password>

9.JPG

    3. If error comes for xuser entry then execute below command to make xuser entry followed by the previous copmm

         xuser -u <DB user>,<Password> -d <DB SID> -n <DB hostname>

10.JPG

       Check the xuser list by executing below command

       xuser -c <DB USER>list

11.JPG

Now the data should come in Solution manager LMDB. It will take some time to reflect the data in LMDB.

Once data is available in LMDB proceed with the Managed system configuration of Database and then Technical monitoring setup and assign template to it. Once the template is applied and activated, data will be reflected in technical
monitoring workcenter.

16.JPG

13.JPG

      Once this is successfully completed go to technical monitoring and assign the templates.

15.JPG

Thanks

Sunny Raj

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Bhupesh Shukla

    Hi Sunny,

    Thanks for the document. Can we use sldreg here as per sap note

    1018839 – Registering in the System Landscape Directory
    using sldreg ?

    Regards,

    Bhupesh

    (0) 
  2. Alex L.

    Hello Sunny,

    what is about the usage rights/license rights in this case?

    Is there a confirmation from SAP side which none-SAP products can be monitored with which support models (standard vs. enterprise support)?

    In case of MaxDB database you might not have problems, but lets assume you would monitor standalone DB like MS SQL, DB2 or Oracle.

    Thank you!

    (0) 

Leave a Reply