The below steps explains how to upgrade the SAP MaxDB version upgrade for the SAP system.
Recently we have upgraded the MaxDB version from 7.9.09 to 7.9.11
For Example: SID – TST
# 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 tstadm or sqdtst (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/TST/db(default path)
3. Installation Client – /sapdb/clients/TST
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)
See also – MaxDB Export/Import via loadercli
Upgrading the Instance and Global location
# Stop the database
Login to DB host and switch to sqd
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 TST -u control,password
(This should be done via root user)
Issue below command to update the MaxDB client.
./SDBINST -i CL_TST
(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 TST – DB Installation
The above commands will update the MaxDB version in all 3 locations.
# Validation of new installed version
Switch to tstadm or sqdtst (depend on installation)
Issue below command –
sdbregview -l
MaxDB version should be consistent for all locations.
# Start SAP system
Click to Read SAP help for SAP MaxDB upgrade