How to Install and Configure SAP DB

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

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

2. Perform a standard configuration of SAP DB.

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

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

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

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

   2. Generate the .XUSER.62 file from the plain text file that you created in Step a.

      Use the SAP DB 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 DB to all nodes where resources for SAP DB 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) command.

   # 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 SAP DB instance.

Example 1–4 Information About a Database User Who Administers an SAP DB 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 DB 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 DB instance is TST.

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

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

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

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

For more information, see the SAP DB documentation.