What is the latest sap hana database version?
Get the previous and also the latest sap hana version details. You will find out what has been improved and what new enhancements and capabilities has been added to the latest version.
===> Get the latest sap hana Version details?
Here is the best place to find out :
How to get full sap hana revision and version information?
There are different ways to obtain the hana version details. Hana studio is the easiest way if you are using a client window interface otherwise using HDB from the server command line is quicker.
How to get sap hana revision and version using sap hana studio?
This method will be the easiest if you have sap hana studio opened on you client interface or on the sap hana server.
How to get sap hana version and revision details using an SQL query?
If you are using the SQL query to retrieve your current sap hana version details, you will be able to get the answer using any sap hana sql interface such as hana studio SQL console or hdbsql.
execute the following SQL syntax : :
hdbsql=> \c -i 02 -d systemdb -u admin_user -p Sys4hundred
Connected to TAX@linux2.lsi.to.world:30213
hdbsql SYSTEMDB=> \al
Aligned output mode switched ON
hdbsql SYSTEMDB=> SELECT * FROM SYS.M_DATABASE;
| SYS | DATABASE | HOST | START_TIME | VERSION | USAGE |
| --- | -------- | ------ | ----------------------------- | ---------------------- | ----------- |
| TAX | SYSTEMDB | linux2 | 2017-07-18 13:33:48.928000000 | 1.00.112.03.1454041151 | DEVELOPMENT |
How to get sap hana version details using HDB?
This method is the quickest if you are already connected as < sid >adm. It provides you with a quick and easy way to copy the result content if you need to paste the details in a report such as a SAP support template request.
taxadm@linux2:/usr/sap/TAX/HDB02> HDB version
HDB version info:
git hash: e0f41240503a1a3398bf7a3eb1171c0fb2eafad4
git merge time: 2016-01-24 00:25:51
compile date: 2016-01-24 00:44:41
compile host: fed7284
compile type: rel
Back to top