Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA platform Installation and Update
and in this video, I will show you how to update the SAP HANA client to the latest version
on Windows using the graphical installer and on Linux as batch command.
Hi, I am Denys van Kempen.
In the previous video, we discussed in some detail the installation of the SAP HANA client.
Assuming you have watched that tutorial, we will move a bit quicker through the update process.
To start, go to the PAM for HANA 2.0.
This is where you can check the latest release notes and installation documentation.
Then, on the SAP Software Download Center tab, select Support Packages & Patches to access
the download area for the latest revision.
Then, scroll down a bit for the SAP HANA client.
First, let’s select 64-bit Linux
Here we have the latest revisions for all three main releases of SAP HANA 2.0: SPS 00, 01 and 02.
I will select SPS 02 and then add the file to the download basket.
The file is only 250 MB, so you also directly download the file, if you prefer.
Then, I will select the 64-bit Windows version and add to the basket.
Now, let’s switch to my Windows client and run the Download Manager
and then just download both files.
Note that they are quite different in size: 250 MB for Linux and 70 MB for Windows.
OK.
Object was completely downloaded.
Now we have two SAR files, how to extract?
For this, we can use the sapcar utility.
It is included with the SAP HANA client, we already installed.
I will copy it to the download folder.
You don’t really need to do this but it will make extracting a bit easier to show.
Alternatively, you could copy sapcar to the Windows system folder so it is in the PATH.
That would work as well.
Let’s open the command prompt.
sapcar -xvf 'name of file'.
Make sure to use the name the Windows version, the 70 MB one.
Open SAP HANA Client.
Right-click hdbsetup and ‘Run as administrator'
Update SAP HANA Database Client.
Installed is 2.2.23.
The update will be 2.2.33.
Next
Upgrade
It is pretty quick
Installation finished successfully.
Finish
Next, the Linux update.
For this, I will use the PuTTY secure copy command again, pscp filename user@host:/path
Enter the password.
You could also set PuTTY up to use public/private keys,
so you could do this as part of a batch command.
Then, I will switch to the Ubuntu server.
Here we have our file.
SAPCAR is in the HANA client.
This time in uppercase.
SAPCAR -xvf filename.
This will extract our SAR file.
Then a cd into SAP_HANA_CLIENT
ls
hdbinst -b for a batch operation - again this is what you would use in a script file -
and the SAP HANA client will be updated.
How do we know what version we got?
Well, you could ask hdbsql.
hdbsql -v
HDBSQL version 2.2.33, the SAP HANA Database interactive terminal.
You could also read the manifest. We can use cat for that.
On Windows use Notepad, it is just a text file.
This will give us all the information we want.
Release 2, revision number 2 and revision patch level 33.
Even a link to the version note is included SAP Note 2339267,
we already looked at this one in the installation video,
and SAP Note 1906576 about HANA client and server compatibility.
That’s it.
Thanks for watching.
You can find more video tutorials on our YouTube channel.
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter - as well for updates -
and we also have a page on Facebook and Google+.
If you are watching this video on YouTube, do not hesitate to leave your comments to
the video page and, if you like, give us your vote on his video.
Thank you for watching.