Upgrading with APO Extract/Load (SAP Library

Upgrading 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 substitute the software (Selecting an Upgrade Strategy).

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

Note

The procedure depends on whether your source version is lower than 7.5.00, or is 7.5.00 or higher, and on your operating system.

If your operating system is UNIX or Linux and your source version is lower than 7.5.00, then you must stop the Structure link X Server and all database instances before the upgrade. Remember that this interrupts communication between the clients and all local database instances. If your source version is 7.5.00 or higher, then the X Server software supports an update of the database software while X Server is running. In this case, you no longer need to stop the X Server and the database instances.

If you are working on Microsoft Windows, you must always stop the X Server and all database instances.

Prerequisites

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

Note

For more information, see the SAP Service Marketplace under http://service.sap.com/upgradeNW2004s

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

· The database instance may be in any operational state.

Procedure

...

1. If necessary, stop each database instance with the following command:

dbmcli –d <database_name> -u <dbm_user>, <password> db_offline

2. If necessary, stop the X Server:

x_server stop

3. Start the SDBUPD program with the following command:

UNIX, Linux:	Microsoft Windows:
./SDBUPD –d <database_name> -u <dbm_user>,<password> [-o <sapdb_user> -g <sapdb_admin>]	sdbupd –d <database_name> -u <dbm_user>,<password>

Note

You then only need to specify the <sdb_user> special operating system user and the <sdba_group>group <sdba_group> if you are performing an upgrade for software version 7.5.00 (see Concepts of the Database System, Structure link Special Operating System Users and Groups UNIX/Linux)).

4. SDBUPD performs the upgrade, and displays a message to indicate whether it has been completed successfully. You are prompted to start liveCache.

5. Start liveCache ( Structure link Starting liveCache).

6. Restore the data from the APO system to liveCache.

Note

For more information, see the SAP Service Marketplace under http://service.sap.com/upgradeNW2004s

Result

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

The liveCache is now in the ONLINE operational state.