Home » Posts tagged 'hana'

Tag Archives: hana

find if a parameter is dynamic in HANA

We many times need to know whether a hana parameter is dynamic or a restart is required to make it effective. To check this goto below

  • open cdexe on the OS side, if you already configured this alias
  • otherwise go to the folder “cd /usr/sap/$SAPSYSTEMNAME/SYS/exe/hdb”
  • open the config folder by command “cd config”
  • open the Master ini files you need with the editor (do not adjust value in these files)
  • check the hint for the parameter you are looking for, there you will find configure online or offline

Example

Below files contains details about

  • Default values (not to be adjusted)
    • /usr/sap/<sid>/HDB<inst>/exe/config
    • /hana/shared/<sid>/HDB<inst>/exe/config
  • Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts
    • /usr/sap/<sid>/SYS/global/hdb/custom/config/<service_or_component>.ini
    • /hana/shared/global/hdb/custom/config/<service_or_component>.ini
  • Valid for all services on all hosts
    • /usr/sap/<sid>/SYS/global/hdb/custom/config/global.ini
    • /hana/shared/<sid>/global/hdb/custom/config/global.ini
  • Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host <host>
    • /usr/sap/<sid>/HDB<inst>/<host>/<service_or_component>.ini
    • /hana/shared/HDB<inst>/<host>/<service_or_component>.ini
  • Valid for all services on a specific host <host>
    • /usr/sap/<sid>/HDB<inst>/<host>/global.ini
    • /hana/shared/<sid>/HDB<inst>/<host>/global.ini

 

uninstall hana cockpit

Note: The versions in my system is below

  • SAP HANA Database – version 2.00.047.00.1586595995
  • SAP HANA XS Advanced Runtime – version 1.0.127.426
  • SAP HANA Cockpit Stack – version 2.0.12.14.0

To Uninstall HANA cockpit please follow below.

  1. GoTo /hana/shared/<Cockpit_SID>/hdblcm20210531_204914
  2. choose option 10, then it will give you below options.20210531_204938
  3. to uninstall all component choose all, or choose the required option and it will give you prompt for y/n, if everything looks good press y to proceed.20210531_205554
  4. then uninstallation will start and once it completes it will give you below details, you should also check the log file mentioned at the last for any issues.20210531_205645

Categories

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers