The project team has requested an SAP HANA 2.0 SPS02 sandbox system so that they can gain experience with the newest SAP HANA 2.0 SPS02 features like multitenant database containers. Update the SAP HANA 1.0 SPS12 sandbox system to SAP HANA 2.0 SPS02.
The SAP HANA database lifecycle management tool (HDBLCM) can be used to update SAP HANA system components like the SAP HANA database and the SAP HANA client software. It can also update additional system components like Application Function Libraries (AFL and the product-specific AFLs POS, SAL, SCA, SOP, UDF), SAP liveCache applications (SAP LCA or LCAPPS-Plugin), SAP HANA extended application services (XS), advanced model (XSA), run-time applications, or SAP HANA smart data access (SDA).
Before you update the SAP HANA database, download the separate components. There are several ways to download the required components, as follows:
Manually via the SAP Software Download Center
Using the Download Components option in SAP HANA cockpit
Using the Maintenance Planner (MP)
Perform an SAP HANA system update from a local host. This minimizes the risk of a failed update because of network glitches.
SAP HANA System Update: Three Tools
The SAP HANA database lifecycle management tool (HDBLCM) can perform all actions offered in the SAP HANA platform lifecycle management portfolio. Three options are provided and used as the only recommended tools for these actions:
- hdblcm (command line)
- hdblcmgui (X Window)
- hdblcmweb (browser)
You do not have to start hdblcmweb manually. The executable hdblcmweb is started automatically by the SAP Host Agent as soon as an action is triggered from the Web user interface.
The SAP HANA lifecycle management tools replace all other tools, such as the SAP HANA unified installer, the on-site configuration tool, SUM for HANA, hdbinst, hdbupd, and the SAP HANA lifecycle manager tools.
Two Ways to Upgrade SAP HANA
There are two versions of the SAP HANA database lifecycle manager tools: the HDBLCM located on the installation media, and the resident HDBLCM embedded in SAP HANA database. Both tools are required, and are used to perform different administrative tasks.
HDBLCM - installation Media
The HDBLCM located on the SAP HANA installation media installs and updates an SAP HANA database and its core components. No additional administrative tasks are possible.
HDBLCM - Resident
The resident HDBLCM performs administrative tasks for the database where it’s embedded. The resident HDBLCM also installs or updates additional SAP HANA components, and can also update the complete SAP HANA database system.
From the menu, choose the option Update the SAP HANA Database System and in the next screen, point the resident HDBLCM to the downloaded and unpacked installation/update kit. The resident HDBLCM will by default verify the downloaded installation/update kit. The rest of the procedure is identical to the update procedure that is performed by the HDBLCM tool.
Checks Before Update Process
Before updating the SAP HANA components, check that no read or write processes are running on the SAP HANA database. Perform the update process outside of business hours, because the SAP HANA system restarts during the update process. After the update finishes, the SAP HANA system is started and operational.
The business downtime is reduced by using the Phased System Update method, or the Near Zero Downtime method. Both methods are explained in this course.
The Update Process
The technical SAP HANA system update can be done in different ways:
Update in one step (standard)
Update for flexible system downtime in 2-phases (option: prepare_update)
The following step-by-step procedure is an example of how to update an SAP HANA system. As there multiple tools for single steps, further variants can be used depending on the knowledge, the needs, and security guidelines given and defined by the customer.
When you start the SAP HANA lifecycle management tool from the SAP HANA cockpit, a user-friendly SAP Fiori interface displays.
How long will the update take?
Time for update = (Time for database shutdown) + (Time for database start) + 20 minutes.
The database restart time is influenced by the size of the row store, and the input/output performance of the storage used for SAP HANA.
With a standard SAP HANA system update, the system goes offline once the update is triggered. This includes the preliminary checks and actual software switch.
With SAP HANA 2.0 the system downtime can be reduced by executing the SAP HANA system update in two phases. The phased system update is performed in two steps, as follows:
- Phase 1
Running the HDBLCM update action with the --prepare_update parameter option. Whilst this phase is running, the SAP HANA system is still in uptime.
- Phase 2
After the first phase of the HDBLCM update has finished, the tool is used again to resume the update procedure, which brings the system to downtime and performs the software switch.
You can perform the prepare update phase using all three variants of the SAP HANA database lifecycle manager HDBLCM. The graphical user interface (hdblcmgui), the command-line interface (hdblcm), or the Web user interface (hdblcmweb) via a browser. The update resume phase can be performed from any of the three SAP HANA database lifecycle manager user interfaces.
Prerequisites for a Phased Update
The prerequisites for a phased update are as follows:
You are updating to a new Support Package Stack from an installation medium, or you have prepared for update, either in the SAP HANA cockpit, or downloaded the required files manually
You have stopped the data replication
You have performed a system backup
You know the
<sid>admand database administrator passwords
You have applied a valid license key for the SAP HANA system
The SAP HANA database server is up and running, otherwise inconsistencies in the configuration may occur