The SAP MaxDB instance requires several options for a user to successfully access a database instance. These required pieces of information must be passed in to the SAP MaxDB tool being used to access the database instance. The SAP MaxDB software includes the xuser tool for simplifying the specification of many required options to SAP MaxDB tools. The xuser tool allows you to predefine and save user data. Once this data has been saved, it can be used when you call the DBMCLI or other tools requiring user options. This predefined user data is stored in a user key (User_Key). An individual user can manage and maintain several user keys for the same or multiple databases. Each key includes a combination of options including username/password, database name as well as database server name.

The SAP MaxDB Recovery Kit requires a valid User_Key for each database instance under protection. This User_Key must be created and accessible by the OS User that owns the database instance. The user information specified for each User_Key must be for a DBM operator with the following permissions:

  • DBStart
  • DBStop
  • DBInfoRead
  • ParamRead

The User_Key can be generated using the command:

xuser –b <file name>

where <file name> is the name of a file containing the valid XUSER entries as follows:

Parameter
Parameter Definition
USERKEY Unique name for the User_Key
USERID User name of the dbm operator
PASSWORD Password of the user
SERVERDB Name of the database instance that this key will refer to
SERVERNODE The name of the server where the database is running (this should be the DNS or host file entry for the SPS protected IP)
SQLMODE This determines what SQL dialects are compatible
CACHELIMIT This determines the cache limits for a given session
TIMEOUT Time in seconds before terminating an inactive session (-1 is the default)
ISOLATION Determines the isolation level used for locks that affect the user (-1 is the default)
DB_LOCAL Specifies the database locale

Refer to the SAP MaxDB User Manual for more information on parameters. Once proper entries have been specified, use the xuser tool to generate the.XUSER.62 file in the OS User home directory. A sample XUSER file is included below containing two keys (an entry must exist for the DEFAULT User_Key).

DEFAULT
NULLDB
NULLDB
NULLDB
LKIP.example.com
INTERNAL
-1
-1
-1
my_locale
LK_USERKEY
LKDBMOPER
LKDBMPASSWD
DB1
LKIP.example.com
INTERNAL
-1
-1
-1
en_US

This example XUSER file specifies that two user keys be created, DEFAULT and LK_USERKEY. Once the xuser tool has been run to generate the User_Key(s), the file specified for use by the xuser tool should not be deleted.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment