How to Update SAP HANA?

If you wish to install latest version of HANA platform prior upgradation of SUM package, you can utilize the following method -

- Prior updating the HANA database, you must search the existing components that would be updated on HANA platform. In addition, you can check the same through hdblcm tool or SAP HANA Studio. Make sure to keep same version of database as well as other components.

Then, in specified log file, users could witness installed versions and products. Prior starting the update, you should not forget backing up the HANA system.

- Download needed software through SAP Support Portal

In such a scenario, you can download the HANA AFL, HANA client, HANA database, HANA Table Redistribution AFL as well as HANA Studio along with SAP Download Manager. Within distributed platform (Wintel is the SAP application server), make sure to not forget download the HANA client for the platforms. Extract and copy every downloaded package to SAP HANA server.

- The HANA database could be updated utilizing Operating System Level commands of SAP HANA Platform Lifecycle Management

In such scenario, the SAP HANA database need to be updated via command line. For the update sequence of HANA database, you need to choose from the following -

- Update HANA Application Function Library or AFL
- Update HANA Database
- Update HANA Client
- Update HANA Table Redistribution AFL
- Update HANA Studio

In order to update the HANA AFL, you need to navigate platform folder as well as run hdbinst as the user root. Following this flow, the whole components need to be installed.

For updating the HANA database, you need to change the HDB_SERVER_LINUX_X86_64 folder as well as run scripthdbupd as the user root. In order to do so, you will require database user SYSTEM' password.

Updating the HANA client requires changing the folder HDB_CLIENT_LINUX_X86_64 and then run hdbinst or hdbsetup, one of these scripts as the user root.

For updating HANA Table Redistribution AFL, users have to change HDB_TRD_AFL_LINUX_X86_64 folder as well as run script hdbinst as the user root.

For the final update of HANA Studio, you have to change HDB_STUDIO_LINUX_X86_64 folder and run hdbinst or hdbsetup, one of the scripts as user root.

Then, in each installation package' log file, you will witness exact package installation path.

- Post update, check the version of SAP HANA database

1. Check the SAP HANA database version with the command line through user sidadm
2. Thereafter, check the SAP HANA version with the HANA Studio or HANA Platform Lifecycle Management