Update Hana DB version

[former_member547765]

Hi,

I need information, what should I pay attention to before i make an update for hana database?

i want to update from hana db version 2.00.036.00.1547699771 to 2.00.037.05.1579051509

here is the detail :

on the hana database server there is:

- SYSTEM DB

and 3 tenant db :

- SIN

- QAS

- DEV

Please help

Regards

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[dvankempen · Accepted solution]

2780510 - SAP HANA 2.0 SPS 03 Database Maintenance Revision 037.01Hi Irfan,

Upgrading to the next revision (36 > 37) is usually not a big change. Latest patch release is 037.06 from May 2020. Always check the notes

• 2551355 - SAP HANA Platform 2.0 SPS 03 Release Note
• 2887843 - SAP HANA 2.0 SPS 03 Database Maintenance Revision 037.06

For more general information about server installations, see my blog post

• https://blogs.sap.com/2018/01/22/sap-hana-2.0-server-installation-and-update-by-the-sap-hana-academy...
  

[former_member547765 · Accepted solution]

Hi denys.kempen

Thanks for the answer, i will check the note.

when i have multi tenant db like i mention before there is SIN, DEV, QAS how can i stop before doing patch?

ussualy on ecc6 i only run stopdb 😄

Regards

[dvankempen]

Hi Irfan,

Correct. As documented

• ALTER SYSTEM STOP DATABASE Statement (Tenant Database Management)

The system database controls the SAP HANA system

• Starting and Stopping SAP HANA Systems

Posted a blog about all of your options some time ago you might still find of interest

• https://blogs.sap.com/2017/09/12/start-and-stop-sap-hana-on-gcp-by-the-sap-hana-academy/

[former_member547765]

Hi Denys,

Thanks for the answer

Regards

[dvankempen]

The software upgrade concerns the SAP HANA system (system database plus all tenant databases) and the upgrade tool (HDBLCM) will stop and start the system as required. There is no need to stop the tenant databases first (unless the notes indicate otherwise). However, if this concerns a production system, downtime should be anticipated. System replication offers near-zero downtime upgrades, if downtime is a concern.

For a quick dry-run, you can download an older version of the express edition and add some tenants and upgrade to a later revision. This will give you an idea of the overall process. Of course, for production systems, this requires a bit more preparation.

[former_member547765]

Hi denys.kempen

can i manually using "alter system stop database SED" to stop tenant DB?

how about to stop SYSTEMDB?

Regards