SAP MaxDB Database

This page explains how to prepare a SAP MaxDB database for the connectivity to SAP Focused Run.

Currently the following monitoring application are supported for SAP MaxDB databases:

Preparations in the Managed Database

TaskActions
PrerequisitesMinimum requirement for the SAP Host Agent is 7.21 SP22
Install SAP Max DB 7.9.08 Client Build 40 or higher

You need at least SAP Max DB 7.9.08 Client Build 40, optionally install the latest SAP MaxDB Client and latest Patches from support.sap.com/swdc -> Databases -> SAP MaxDB

The installation of the MaxDB Client is described in SAP Note 649814.

Create the User Store
  • If a sapdbctrl user is already created on Max DB, remove it.
  • As root User, add Write permissions to the /usr/sap/hostctrl/exe folder
  • Create the User Store for sapadm: /usr/sap/hostctrl/exe/saphostctrl -host <hostname> -user sapadm <password> -dbname <dbname> -dbtype ada -function SetDatabaseProperty DBCredentials=SET -dboption User=SUPERDBA -dboption Password=<SUPERDBA Password>
  • Delete the Write permissions to the /usr/sap/hostctrl/exe folder.

See also how to set connection information in SAP Note 2018919

Note: can be automated by os script

Check created User Store

Check created User Store: /sapdb/programs/bin/xuser list

Note: can be automated by os script

Check Database status

Optional (eg. for debugging)

/hostctrl/exe/saphostctrl -function ListDatabases
/hostctrl/exe/saphostctrl -function GetDatabaseStatus –dbname <DBNAME> -dbtype ada

Run Outside Discovery on the HostAs prerequisites, you shall install the SAP Host Agent and run Outside Discovery as described in page Preparing Outside Discovery.