In-Place Migration with SDBUPD 

Use

You are using the program SDBUPD to upgrade the database instance.

The source version of the database software is Version 7.3 Build ³ 025, the target version is ³ 7.4.03 (Selection of the Upgrade Strategy).

Use this procedure if the database instance is combined with an SAP system.

This upgrade strategy is valid for database instances of the type SAP DB OLTP only. It is valid for all supported operating system platforms.

There can not be any remote communication between the database instances and applications during the upgrade, since the V Server software (X Server service) may need to be switched, depending on the source and target version of the upgrade. Therefore, stop all database instances, so that SDBUPD can stop any X Servers that are still running. Alternatively, you can stop the X Server yourself, before the upgrade.

Prerequisites

·        The database instance you want to update is part of an SAP system.

·        The database instance is in the operational state ONLINE.

·        The database instance is the only instance that refers to the installation path of the software version you want to update.

·        The database parameters of the database instance you want to upgrade have not changed since the last restart.

Procedure

	Description	Command
1.	Call the Database Manager CLI as the DBM user and connect to the database instance.	dbmcli –d <database_name> -u <dbm_user>,<password>
2.	Switch the database instance to the operational state OFFLINE.	db_offline
3.	Switch the database instance to the operational state COLD (up to Version 7.3) or ADMIN (from Version 7.4).	db_cold | db_admin
4.	If you have a newer data backup, make an incremental data backup and a log backup. Otherwise, make a complete data backup (Backing Up the Database Instance).	backup_start <medium> [<type>] [AUTOIGNORE]
5.	Exit the Database Manager CLI.	exit | release | quit | bye
6.	Stop the X Server.	x_server stop
7.	Start SDBUPD. SDBUPD performs the upgrade, and displays a success message if completed successfully. It then flags the installation as complete. The execution of this command can take a long time. Never terminate it. If you do, you risk losing all your data. Your only option in this event is to use data backups to go back to the corresponding state of the database instance.	UNIX/Linux: ./SDBUPD –d <database_name> -u <dbm_user>,<password> Microsoft Windows: sdbupd –d <database_name> -u <dbm_user>,<password>

 

Result

The OLTP database instance and its software has been updated.

The database instance is in the operational state ONLINE.