SAP MaxDB Database Version Upgrade Steps

[adil_fahim]

The below simple steps explains how to upgrade the SAP MaxDB database for the SAP system.

Recently we have upgraded the MaxDB version from 7.9.09 to 7.9.11

# Download new SAP MaxDB patches from Software Download Center (SWDC) -> Databases -> SAP MaxDB

# Stop the SAP system

# To check the current version of SAP MaxDB database - Login to database system and switch to <sid>adm or sqd<sid> (depend on your installation)

Issue below command:

sdbregview -l

The above command will display the present MaxDB version including below 3 locations -

1. Installation Global - /sapdb/programs(default path)
2. Installation Database - /sapdb/<sid>/db(default path)
3. Installation Client - /sapdb/clients/<sid>(default path)

Validate the version in all above 3 locations and note down the details.

# Login in dbmcli from OS level (Another way of validation)

Issue below command:

dbm_version

The above command will also display the DB version and installation root directory.

# To check how many databases are running on host (in case of multi DB installation)

db_enum

The above command will display all the MaxDB instances running on host including installation root directory with status(running/offline)

Upgrading the Instance and Global location

# Stop the database
Login to DB host and switch to sqd<sid> or <sid>adm
Login via dbmcli from OS level

Issue below command:

db_offline

Validate status post shutdown:

db_state

# Upgrade procedure
Login to DB host as user root.
Navigate the downloaded SAP MaxDB file and extract the media

Issue below command to update the database.

./SDBUPD –d <database_name> -u control,<password>
(This should be done via root user)

Issue below command to update the MaxDB client.

./SDBINST -i CL_<SID>
(This should be done via root user)

Issue below command to update the MaxDB Global Location.

./SDBINST -update_global
(This should be done via root user)

Choose <SID> - DB Installation

The above commands will update the MaxDB version in all 3 locations.

# Validation of new installed version
Switch to <sid>adm or sqd<sid> (depend on installation)

Issue below command -

sdbregview -l

MaxDB version should be consistent for all locations.

# Start SAP system