Create the SAP MaxDB Database

Follow the instructions in your SAP MaxDB User Manual to create your database. In addition, please note the following recommendations:

• There must be a DBM operator with authority for starting, stopping, obtaining status and obtaining database parameters via client utilities.

• The database instance data device spaces (data devspaces), log device spaces (log devspaces) and system device spaces (sys devspaces) must reside on a shared disk (either shared file system, or shared raw device).

• The SAP MaxDB database name should contain alphanumeric characters only.

• A User_Key is required for use by the SAP MaxDB Recovery Kit during operation with the DBMCLI utility. See Create the User_Key for required parameters.

• After creating your database, you should disable automatic startup of the SAP MaxDB database instance. Once under LifeKeeper protection, LifeKeeper will handle the start and stop of the database.

• The sdb file must exist on all servers in /etc/opt. If this file does not exist, several SAP MaxDB utilities may return erroneous results. This will also affect the behavior of LifeKeeper during resource create and extension. In an Active/Standby configuration, you must manually copy this file to the backup server.

• Verify the databases.ini file exists on all servers in the IndepDataPath/config directory.

• Copy each database entry in the databases.ini file that will be configured with LifeKeeper to the backup server.

The steps to configure the maxdb resource are as follows:

1. Create a log folder in the MaxDB folder as the maxdb user.

   1. cd /sapdb/MAXDB/

   2. mkdir log

2. Navigate to the programs folder. This folder is /sapdb/programs by default, unless it was changed during installation.
   1. sudo su -sdb
      

      su -sdb

   2. ./dbmcli -s -R /sapdb/MAXDB/db db_create DEMODB dbm,dbm
      

      ./dbmcli -s -R /sapdb/MAXDB/db db_create DEMODB dbm,dbm

   3. ./dbmcli -d DEMODB -u dbm,dbm
      

      ./dbmcli -d DEMODB -u dbm,dbm

   4. user_put dbm PASSWORD=dbadmin
      

      ./dbmcli on DEMODB>user_put dbm PASSWORD=dbm_password

   5. param_startsession
      

      ./dbmcli on DEMODB>param_startsession

   6. param_init OLTP
      

      ./dbmcli on DEMODB>param_init OLTP

   7. param_put CAT_CACHE_SUPPLY 5000
      

      ./dbmcli on DEMODB>param_put CAT_CACHE_SUPPLY 5000

   8. param_put CACHE_SIZE 3000
      

      ./dbmcli on DEMODB>param_put CACHE_SIZE 3000

   9. param_put MAXDATAVOLUMES 5
      

      ./dbmcli on DEMODB>param_put MAXDATAVOLUMES 5

   10. param_put RUNDIRECTORYPATH /sapdb/MAXDB/run
       

       ./dbmcli on DEMODB>param_put RUNDIRECTORYPATH /sapdb/MAXDB/run

   11. param_checkall
       

       ./dbmcli on DEMODB>param_checkall

   12. param_commitsession
       

       ./dbmcli on DEMODB>param_commitsession

   13. param_addvolume 1 DATA /sapdb/MAXDB/data/DISKD0001 F 2560
       

       ./dbmcli on DEMODB>param_addvolume 1 DATA /sapdb/MAXDB/data/DISKD0001 F 2560

   14. param_addvolume 1 LOG /sapdb/MAXDB/log/DISKL001 F 2048
       

       ./dbmcli on DEMODB>param_addvolume 1 LOG /sapdb/MAXDB/log/DISKL001 F 2048

   15. quit
       

       ./dbmcli on DEMODB>quit

   16. ./dbmcli -d DEMODB -u dbm,db_password db_start
       

       ./dbmcli -d DEMODB -u dbm,db_password db_start

   17. ./dbmcli -d DEMODB -u dbm,db_password
       

       ./dbmcli on DEMODB

   18. util_connect dbm,db_password
       

       ./dbmcli on DEMODB>util_connect dbm,db_password

   19. db_activate dba,dba
       

       ./dbmcli on DEMODB>db_activate dba,dba

   20. load_systab -u dba,dba -ud domain
       

       ./dbmcli on DEMODB>load_systab -u dba,dba -ud domain