My Experience in SAP/HANA

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

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/

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 do...