How to Install and Configure MaxDB

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

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

2. Perform a standard configuration of MaxDB.

3. Create the .XUSER.62 file in the home directory of the operating system (OS) user who administers the MaxDB instance.

   ---

   Note –

   If you are using MaxDB 7.5 or MaxDB 7.6, the UNIX user identity of the OS user who administers the MaxDB database is sdb. You need to specify this user when you create the MaxDB resource in a later step. Otherwise, the MaxDB fault monitor cannot probe the MaxDB database.

   ---

   1. Create a plain text file that contains information about the database user who administers the MaxDB database instance.

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

      For an example of the content of this file, see Example 4.

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

      Use the 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 MaxDB to all nodes where resources for MaxDB and SAP xserver will run.

   To ensure that the same owner owns the directory and its contents on all nodes, use the tar(1) command and the rsh(1)

   # tar cfB - /usr/spool/sql | rsh destination 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 who administers an MaxDB instance.

5. If you are installing MaxDB 7.5 or MaxDB 7.6, perform this step. If you are installing a previous version, proceed to the next step.

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

   To ensure that the same owner owns the directory and its contents on all nodes, use the tar(1) command and the rsh(1)

   # tar cfB - /etc/opt/sdb | rsh destination 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 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 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 MaxDB instance is TST.

• The logical host name for the MaxDB resource is srvr-1.

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

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

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

For more information, see the MaxDB documentation.