HDBUSERSTORE pointing to wrong hostname

Details: SAP is installed with alias name. Hdbuserstore always points to alias name, but instead I wanted it to point to the hostname to which it is required.

Solution:

The snote that is helpful to resolve this issue is 2120226 - SAP HANA client software and entries in hdbuserstore when using virtual host names for SAP application servers.

Under the /usr/sap/SAPSID/hdbclient/install , there is a file "installation.ini" .
Modify the parameter - Hostname=<hostname/aliasname>

This will redirect the command "hdbuserstore list" to look for the correct directory and key files.

If it is only HANA , then the location of the hdbuserstore is always pulled from the environment variables.

Eg: Check for the following env variables 

    HDB_USE_IDENT 

   or from /hana/shared/(SID>/HDBXX/home/.sapenv.csh or .sapenv.sh

Crontab

Came across the following website which is helpful in setting the cron job conditions. Give your inputs and it will show on what data/time is the job going to occur.

https://crontab.guru/

SAP Client Copy Profiles

Always, it has been a pain to search / understand what data is copied/deleted during a SAP client copy.

Most of the blogs online has the procedure to do a SAP Client copy. The following points are helpful in performing a client copy.

1. Take a backup of the Source Client. This is easier method to restore the application data as it is deleted with most of the profiles.
2.  Try to do a Remote client copy as it does not require space on File system.

Copy Profile	Meaning	User Data	Customizing	Application data
SAP_USER	Users, user roles and authorization profiles are copied. The client is not reset.	Yes	No	No
SAP_CUST	Client-dependent Customizing, including authorization profiles, are copied. The application data is deleted and the user data is retained.	No	Yes	No (will be deleted)
SAP_UCUS	corresponds to SAP_CUST with master data	Yes	Yes	No (will be deleted)
SAP_ALL	All data belonging to a client, with the exceptions of change documents and local data, is copied.	Yes	Yes	Yes
SAP_APPL (as of SAP Web AS 6.10)	SAP_ALL without user master data	No	Yes	Yes