HANA SPS version check

[Former Member]

Hi,

How can i find out the current HANA SPS version, HDB version does not mention the SPS info.

HDB version

HDB version info:

version: 1.00.41.370506

branch: NewDB100_REL

  git hash:            not set

  git merge time:      not set

weekstone: 0000.00.0

  compile date:        2012-11-13 10:27:17

  compile host:        ldm053.server

  compile type:        opt

Thank you

Jonu Joy

[nicholas_steffens]

Here's an extract from https://www.blue.works/en/hana-version-numbering-explained/ which will explain where to find the SPS number.

--------------------------

2.00.024.05.1520347815 — If that’s totally clear for you, no need to read further, everyone else let’s start!

HANA version, support package, SPS, revision, patch, maintenance revision. Please update the SPS03 to latest revision including any patches. Easy? Or a bit confused?

SAP has created a detailed versioning for their HANA lifecycle management. It can be a bit confusing and overwhelming at first, but actually it’s quite easy and logical. Let’s break down the long version number so everything becomes clear.

First part “2.00.” is for HANA overall version.

Next part “02” is for the support package stack, short SPS. This blends into the revision number (short rev) — “4”. And now it might become a bit confusing. Namely, the SPS number is rarely used and much more often its just referred as the revision number — “024”. Every time the decimal in revision is full, a new SPS is announced.

Next part “05” is the patch number, sometimes it’s also referred as maintenance revision number.

Last part “1520347815” is a reference number for the build. This one is the least important when it comes to understanding version numbers and is usually not needed.

--------------------------

Regards,

Nick

[Former Member]

Hi,

First of all,

You need MONITOR_ADMIN previlege under "System Previleges" to see this screen or ask your system user to verify the DB version.

HANA Studio version can be checked by :

Help->About SAP HANA Studio.

It will be like

Version: 1.0.27

Build id: 201205021925 (361805)

Here 1.0.27 means -> 1.0 version and Revision is 27 and Build No is : 361805

HANA DB version can be checked by :

Right click the System(Eg:IN1 (SYSTEM)) under Navigator->Properties...->Version History

This will list all the versions using which the DB is upgraded and the Installation Time.The top most one would be current version of your HANA DB

Kind rgds,

Ashwin Mane

[Former Member]

This message was moderated.

[former_member182921]

Hi,

You can check the SPS version from hana Studio .

Regards ,

Abhi

[Former Member]

Hi Abhi,

How can do it? version history? Help->About?

Regards

SZW

[lbreddemann]

Hello Jonu,

basically you have to check the documentation/release note for that:

http://help.sap.com/hana_appliance#section1

In the referenced sap note 1771691 you'll find that:

"The SAP HANA Appliance Software SPS 05 contains SAP HANA database Revision 45"

- Lars

[Former Member]

thx Much Lars, would have been good if we could have seen that from studio or HDB version.