Sap hana hdbuserstore parameter details?
The use of sap hana user store key is recommanded whenever you are using automated procedures which connect to a database.
reating a key is easy to do. The following parameter details will help to proceed and create a user store key successfully.
Here is are all the possible options to create and manage sap hana user store key :
faxadm@linux7:/usr/sap/FAX/HDB07 > hdbuserstore
Usage: hdbuserstore [ options ] command [ arguments ]
-u < USER > perform operation for other operating system user
-v verbose mode, print operations done
-i interactive mode, ask for missing values
-h this help message
-H < HOST > assume host name < HOST >
Print help message.
SET < KEY > < ENV > < USERNAME > < PASSWORD >
Set a profile entry.
< KEY > entry key
< ENV > connection environment (host and port)
< USERNAME > user name
< PASSWORD > password
DELETE < KEY >
Delete entry with key < KEY >.
LIST [< KEY > ...]
List entries of store. The passwords are not shown.
Generate new encryption key and encrypt passwords again.
Typical syntax to create a sap hana user store key?
Here is a standard syntax to create a hana user store key. All you need is the Name of the Key, the Full server name, the port number, the user acoount name and his password. If you are looking at tenant database, you can add the database name in the command.
Syntax : hdbuserstore -i set < Name of the user store key > < Full server name >:< Port number >@< database name > < The database user account > < The database user password >
How to find the full host name to create a sap hana user store key?
The Full server name, which you need to create the hana user store key with, can be retrieved using the following nslookup command. Note, this is not the only way to get the server full name.
#-- Get full hostname
faxadm@linux7:/usr/sap/FAX/HDB07> nslookup `hostname`
#-- set host name in hdbuserstore
faxadm@linux7:/usr/sap/FAX/HDB07> hdbuserstore -i set ATENANTDBBACKUP linux7.ard.usa-tcl.bx:30713 AUSERBACKUP AuserBACKUP01
Which default port number to use to create a hana user store key?
The Port number has a different structure depending on whether you are dealing with a single database or a multitenant database architecture.
Here is the default port number format :
Port number : 30< Instance_ID >:15 - for a single database architecture
Port number : 30< instance_ID >:13 - for a multitenant database architecture
For a tenant database which belong to a multitenant environment databases with a hana instance of 07 the port number will be : 30713
faxadm@linux7:/usr/sap/FAX/HDB07> hdbuserstore -i set USERBACKUPKEY linu.ard.usa-tcl.bx:30713 BACKUPUSER passHere01