Skip to Content
Author's profile photo Former Member

Technical Monitoring – MaxDB database on Windows.

  Technical monitoring of MaxDB database on Windows.

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

Execute transaction DB59:


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

  Select MaxDB and then continue.


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


  Once details are entered save it.



   After saving click on to DBA Cockpit now:


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


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


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

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


    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>


       Check the xuser list by executing below command

       xuser -c <DB USER>list


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.



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



Sunny Raj

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sunny,

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

      1018839 - Registering in the System Landscape Directory
      using sldreg ?



      Author's profile photo Former Member
      Former Member

      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!