DBACOCKPIT and Solman Monitoring for MaxDB Database : How to Setup -I
You have a requirement of setting up central administration of your MaxDB database to be monitored by SOLMAN 7.1 system, running on Oracle/Linux or any other DB/OS other than MaxDB.
MaxDB database instance might be standalone or an SAP application may be running on it. Content server, live cache or complete SAP system.
Also you would like to configure DBA planning calendar to schedule database backups and other DB related task centrally from solution Manager.
To achieve this, we should be able to connect to the MaxDB database instance from the solution manager 7.1 system to access database information. To realize this connection, we need to have a compatible version of MaxDB client libraries installed on all the application servers of the solution manager system.
Maxdb client is not installed by default if you are running the DBACOCKPIT on a SAP system which is running on a database other than MaxDB.
How to check if the client is installed or not on your system.
- Check for the Maxdb client installation on all application servers of system using Tcode SE38/SA38 and program RSADA_CHECK_SERVERS
2. Download and Install the MaxDB Client Libraries.
Download the maxdb client runtime package from service market place. File with name MAXDBART<XXXX_XX-XXXXXXXX.SAR
Once it has been downloaded , install it as shown in steps below and run the installation using command ./SDBINST
Set group to “sapsys” and owner to “sidadm” and continue. You can also create standard group and user but make sure that sidadm user has access to read client libraries .
Set the environment variables PATH and LD_LIBRARY_PATH and include the path of the lib and programs/bin for MaxDB client on all application servers. Logoff and login again from the shell so that the changes can take effect.
3. Download the Maxdb database library ( this is different from Maxdb client libraries) , depending upon your kernel version and uncar it to the SAP kernel directory
In my case as I am running on linux, we downloaded the linux compatible library.
Uncar and copy the library dbsdbslib.so to the SAP kernel directory
Once the environment variables have been set, and the MaxDB library copied to the SAP kernel, for the changes to take effect, restart the application servers.
Now test the client installation using the program RSADA_CHECK_SERVERS again
4. Now we are all set to define a database connection in DB59 to a remote MaxDB database
Once this has been setup , we are all set to monitor the database in DBACOCKPIT.
In the next document related to MaxDB, i will explain how to setup DBA planing calendar to schedule activities like DB backup , log backup , check database and other activities central from the DBACOCKPIT for a remote MaxDB database.
Also I will explain, how to create the database connection from SOLMAN 7.1 managed system setup instead of creating it manually and how to setup and configure diagnostics agent and outside discovery for a Maxdb database instance and how to configure monitoring for a MaxDB remote database in SOLMAN 7.1 MAI , which is running standalone or as part of content server or livecache database.