Managing Serviceguard Extension for SAP Version B.05.10, September 2010

Additional Steps for MAXDB
Logon as root to the primary host of the database where the db or dbci package is running in
debug mode.
MAXDB Database Step: SD930
If environment files exist in the home directory of the MAXDB user on the primary node, create
additional links for any secondary.
Example:
su - sqd<sid>
ln -s .dbenv_<primary>.csh .dbenv_<secondary>.csh
ln -s .dbenv_<primary>.sh .dbenv_<secondary>.sh
exit
MAXDB Database Step: SD950
Make sure that /usr/spool exists as a symbolic link to /var/spool on all cluster nodes on
which the database can run.
MAXDB Database Step: SD950
Configure the XUSER file in the <sid>adm user home directory.
The XUSER file in the home directory of the SAP Administrator keeps the connection information
and grant information for a client connecting to the SAPDB database. The XUSER content needs
to be adopted to the relocatable IP the SAPDB RDBMS is running on. To list all mappings in the
XUSER file, run the following command as <sid>adm:
# dbmcli -ux SAPR3,SAP -ul
For MAXDB 7.6:
su - <sid>adm
dbmcli -ux SAP<SID>, <password> -ul
This command produces a list of SAPDB user keys that may be mapped to the SAPDB database
schema via a local hostname. SAP created keys commonly include c, w and DEFAULT. If a mapping
was created without specifying a key, entries of the form <num><SAPDBSID><hostname>, e.g.
1SDBrhpcc072 exist. These will only work on one of the cluster hosts.
To find out if a given user key mapping <user_key> works throughout the cluster, the relocatable
address should be added to the primary host using cmmodnet -a.
For all previously listed user keys run the following command as <sid>adm Administrator:
# dbmcli -U <user_key>
quit exits the upcoming prompt:
# dbmcli on <hostname> : <SAPDBSID>> quit
<hostname> should be relocatable. If it is not, the XUSER mapping has to be recreated.
Example:
# dbmcli -d <SAPDBSID> -n <reloclc_s> -us <user>,<passwd> \ -ux SAPR3,SAP -uk <user_key>
Entries of the form <num><SAPDBSID><reloclc_s> could be created by omitting the -ukoption.
NOTE: Refer to the SAP documentation to learn more about the dbmcli syntax.
After recreation always check the connection:
# dbmcli -U <user_key>
# dbmcli on <reloclc_s> : <SAPDBSID>> quit
MAXDB Database Step: SD960
Distribute the XUSER mappings by distributing the file /home/<sid>adm/.XUSER.<version>
to all database package nodes.
MAXDB Database Step: SD965
Database Configuration 101