Verifying the SAP MaxDB Installation and Configuration

Language:

Before you install the HA for SAP MaxDB packages, verify that the SAP MaxDB software is correctly installed and configured to run in a cluster. This verification does not verify that the SAP MaxDB application is highly available because the HA for SAP MaxDB data service is not yet installed.

How to Verify SAP MaxDB Installation and Configuration on Each Node

Perform this procedure on each node that can master the SAP MaxDB resource group.

Assume the root role on a node that can master the SAP MaxDB resource group.

Switch the SAP MaxDB resource group to the node that you logged in to in Step 1.
```
# clresourcegroup switch -n node sapdb-rg
```
-n node

Specifies the node to which the SAP MaxDB resource group is to be switched

sapdb-rg

Specifies that the SAP MaxDB resource group sapdb-rg is to be switched to another node

Confirm that the SAP MaxDB database can be started and be stopped.
1. Become the OS user that administers the SAP MaxDB database.
```
# su - os-sapdb-adm-user
```
  os-sapdb-adm-user
  
  Specifies the UNIX user identity of the OS user that administers the SAP MaxDB database. This user's home directory contains the .XUSER.62 file that was created during the installation and configuration of SAP MaxDB. For more information, see Installing and Configuring SAP MaxDB. You specify this user when you set the DB_User extension property as explained in How to Register and Configure a SAP MaxDB Resource.
2. Start the SAP xserver.
```
$ x_server start
```
3. Manually start the SAP MaxDB database instance on the node that you logged in to in Step 1.
```
$ dbmcli -U sapdb-adm-key db_online
```
  -U sapdb-adm-key
  
  Specifies that the dbmcli command is run with the user key of the database user who administers the SAP MaxDB instance. This user key is created during the installation and configuration of SAP MaxDB. For more information, see Installing and Configuring SAP MaxDB. You specify this user key when you set the User_Key extension property as explained in How to Register and Configure a SAP MaxDB Resource.
4. Confirm that the SAP MaxDB database instance is started.
5. Manually stop the SAP MaxDB database instance.
```
$ dbmcli -U sapdb-adm-key db_offline
```
  -U sapdb-adm-key
  
  Specifies that the dbmcli command is run with the user key that you used for starting the database in Step 3.c
6. Confirm that the SAP MaxDB database instance is stopped.