Patch Installation with SDBUPD 

Use

You are using the program SDBUPD to upgrade the database instance. This switches the SAP DB software only.

You can use this procedure only if the build number only has changed between the source and target version (SAP DB Version Notation). In this case, the software does not have a significant amount of new functions that could cause incompatibilities between the existing data and the new software.

You use this upgrade strategy if your database instance is part of an SAP system (Selection of the Upgrade Strategy).

You can use this procedure even if the database instance is not combined with an SAP system. To do this, however, you must fulfill the following prerequisites:

·        You used SDBINST to install the existing software (with a tgz package or a zip file, and not with an rpm package)

·        Each database instances refers to a separate software installation.

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

Before you start the upgrade, make sure that you have up-to-date log backups and/or data backups for recovering the database instances in the event of errors.

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

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

·        The database instances is in one of the three defined operational states.

·        You have stopped all database instances, or, alternatively, the X Server.

Procedure

...

Start SDBUPD with the following command:

UNIX, Linux:	Microsoft Windows:
./SDBUPD –d <database_name> -u <dbm_user>,<password>	sdbupd –d <database_name> -u <dbm_user>,<password>

SDBUPD performs the upgrade, and displays a success message if the upgrade is completed successfully. It then flags the installation as complete.

Result

The database instance and its software have been updated.

If you have updated a liveCache database instance, it is now in the operational state OFFLINE.

If you have updated a SAP DB OLTP database instance, it is now in the operational state ONLINE.