You use the SDBUPD program to upgrade a database instance. When you do this, only the database software is replaced.
You can use this procedure for software version 7.6.x where only the version build number has changed between source and target version and for upgrades from 7.4.03 to 7.6.x and version 7.5.x to 7.6.x (see also Selecting an Upgrade Strategy).
You use this upgrade strategy if your database instance is part of an SAP system.
You can use this procedure even if the database instance is not integrated in an SAP system. To do this, however, the following prerequisites must be fulfilled:
● The SDBINST program must have been used to install the existing software (that is, with a tgz package or a zip file, and not an rpm package).
● Each database instance must refer to a separate software installation.
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 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. You no longer
need to stop the X Server. The database instance that you want to upgrade is
stopped by SDBUPD during the upgrade.
If you are working on Microsoft Windows, you must always stop the X Server and all database instances.
Before you
start upgrading a database instance, make sure that you have up-to-date log backups
and/or
data
backups for recovering this database instance in the event of
errors.
The database parameters of the database instance you want to upgrade must not have been changed since the last restart.
● The database instance you want to upgrade is the only instance that refers to the installation path of the software you want to update.
● The database instance is in a defined operational state - in other words, no errors may exist.
...
1. If necessary, stop each database instance with the following command one by one:
>dbmcli –d <database_name> -u <dbm_operator>,<dbm_operator_password> db_offline
2. If necessary, stop every individual scheduler:
>dbmcli –d <database_name> -u <dbm_operator>,<dbm_operator_password> scheduler_stop
3. If necessary, stop the X Server:
>x_server stop
4. Start the SDBUPD program for the database instance by entering the following commands:
UNIX, Linux: |
Microsoft Windows: |
>./SDBUPD –d <database_name> -u
<dbm_user>,<password> |
>sdbupd –d <database_name> -u <dbm_operator>,<dbm_operator_password> |
You only need
to specify the <sdb_user>special operating system user and the <sdba_group> if you are performing an upgrade for a software
version below 7.5.00 (see Concepts of the Database System, Special Operating
System Users and Groups UNIX/Linux)).
SDBUPD performs the upgrade, and displays a message to indicate that the upgrade has been completed successfully. It then flags the installation as complete.
The specified database instance and software belonging to the Server profile have been updated.
With this procedure, the software not belonging to the Server installation profile is not updated. To update this software, use SDBINST as described under Installing and Updating the Database Software.
If you have
upgraded a liveCache database
instance, it is now in the OFFLINE operational state.
If you have
upgraded an OLTP database
instance, it is now in the ONLINE operational state.