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.
- 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
Once this is successfully completed go to technical monitoring and assign the templates.