Upgrade with APO Extract/Load 

Use

You use the SDBUPD program for an upgrade with APO Extract/Load. You must first back up the transaction data of the application system from the liveCache database instance to the APO database, and then switch the software (Selection of the Upgrade Strategy).

This procedure is currently valid only for the instance type liveCache in the SAP APO system. It is valid for all operating system platforms supported by SAP DB.

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

·        You have backed up the liveCache transactions to the APO database.

SAP customers can find information on this in the Service Marketplace under http://service.sap.com/instguides ® Installation ® Installation & Upgrade Guides ® mySAP SCM ® Using SAP APO 3.1SR1... ® Upgrade Information  ® Upgrade for SAP APO 3.1: SAP liveCache 7.4 ® Upgrade Preparations.

·        You have stopped all database instances, and possibly the X Server as well.

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

·        The database instance can be in any operational state.

Procedure

...

       1.      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>

       2.      SDBUPD performs the upgrade, and displays a success message if completed successfully. You are prompted to start liveCache.

       3.      Start liveCache (Starting liveCache).

       4.      Recover the data from the APO system to liveCache (see the link to Upgrade for SAP APO 3.1: SAP liveCache 7.4.), above.

Result

The liveCache database instance in the SAP APO system and its software have been upgraded.

liveCache is in the operational state ONLINE.