Oracle^® Solaris Cluster Data Service for SAP MaxDB Guide

How to Install and Configure SAP MaxDB

1. On one node of the cluster, install the SAP MaxDB software.

   Ensure that you install SAP MaxDB on its own global device group.

2. Perform a standard configuration of SAP MaxDB.
3. Create the .XUSER.62 file in the home directory of the operating system user that administers the SAP MaxDB instance.
   1. Create a plain text file that contains information about the database user that administers the SAP MaxDB database instance.

      For information about the content of this file, see the SAP MaxDB documentation. For the name of the server on which the database is running, specify the logical hostname for the SAP MaxDB resource that you specified in Configuration Planning Questions.

      For an example of the content of this file, see Example 4, Information About a Database User Who Administers a SAP MaxDB Instance.

   2. As the SAP MaxDB admin user, generate the .XUSER.62 file from the plain text file that you created in Step a.

      Use the SAP MaxDB command xuser for this purpose.

      # xuser -b user-info-file

      -b user-info-file

      Specifies the plain text file from which you are generating the .XUSER.62 file

4. Copy the /usr/spool/sql directory and its contents from the node on which you installed SAP MaxDB to all nodes where resources for SAP MaxDB and SAP xserver will run.

   To ensure that the same owner owns the directory and its contents on all nodes, use the tar command and the ssh command.

   # tar cfB - /usr/spool/sql | ssh destination "cd /;tar xfB -"

   destination

   Specifies the node to which you are copying the /usr/spool/sql directory and its contents

   The following example shows a plain text file that contains information about a database user that administers an SAP MaxDB instance.

5. Distribute /etc/opt/sdb on all nodes to run SAP MaxDB.

   Copy the /etc/opt/sdb directory and its contents from the node on which you installed SAP MaxDB to all nodes where resources for SAP MaxDB and SAP xserver will run.

   To ensure that the same owner owns the directory and its contents on all nodes, use the tar command and the ssh command.

   # tar cfB - /etc/opt/sdb | ssh destination "cd /;tar xfB -"

   destination

   Specifies the node to which you are copying the /etc/opt/sdb directory and its contents

Example 4  Information About a Database User Who Administers a SAP MaxDB Instance

DEFAULT
dbm
dbm
TST
srvr-1
blank line
blank line
-1
-1
blank line

This example specifies the following information about a database user who administers an SAP MaxDB instance:

• The user key that is used to address this combination of XUSER data is named DEFAULT.

• The user name and password of the database user are dbm.

• The name of the SAP MaxDB instance is TST.

• The logical hostname for the SAP MaxDB resource is srvr-1.

• No structured query language (SQL) mode is specified.

• The default time-out value of the SAP MaxDB instance is used.

• The default isolation level of the SAP MaxDB instance is used.

For more information, see the SAP MaxDB documentation.