Procedure documentationUpgrade if Indidual Database Uses the Software Installation Locate this document in the navigation structure

 

Use the SDBUPD program to upgrade a database. In this process, update the existing software and simultaneously upgrade the existing database to this new version.

The SDBUPD program automatically stops the database to be upgraded during this process.

On Microsoft Windows, the SDBUPD program also stops X Server. On Unix/Linux, stopping X Server is not necessary since from version 7.5 the X Server software supports an update of the database software while X Server is running.

On any operating system, you must stop all DBM Server processes. In case the scheduler is running on the database to be upgraded, stop the scheduler before starting the SDBUPD program. After having performed the upgrade, you must re-start the scheduler for the jobs to be executed.

Recommendation Recommendation

Before you start the upgrade process, make sure you have up-to-date log backups and data backups for recovering the database in the event of an error.

If you have changed parameters of the database to be upgraded after the last restart , we also recommend that you first restart the database. This will prove that your database is still restartable and that no inconsistent changes have been made. Only then start the upgrade process to make sure that it does not fail because of parameter inconsistencies.

End of the recommendation.

Prerequisites

  • The SDBINST program or Installation Manager has been used to install the existing software.

  • The database is in a defined operational state - in other words, no errors may exist.

  • It is the only database which uses the software to be updated.

Procedure

  1. Log on to Database Manager CLI in session mode as a DBM operator and connect to the database to be upgraded:

    >dbmcli -d <database_name> -u <dbm_operator>,<dbm_operator_password>

  2. Check whether the scheduler function is active:

    >scheduler_state

  3. If the scheduler function is active, stop it using the following command:

    >scheduler_stop

    Otherwise proceed with step 4.

  4. Exit Database Manager CLI:

    >exit

  5. Start the SDBUPD program by entering the following command:

    Microsoft Windows

    UNIX/Linux

    >sdbupd -d <database_name> -u <dbm_operator>,<dbm_operator_password>

    >./SDBUPD -d <database_name> -u <dbm_operator>,<dbm_operator_password>

    SDBUPD performs the upgrade and displays a message to indicate that the upgrade has been completed successfully. It then flags the installation as complete.

Result

The specified database and the software belonging to the Server installation profile have been updated.

Caution Caution

With this procedure, the software not belonging to the Server installation profile is not updated. To update this software, use the SDBINST program as described under Installing or Updating the Software Using SDBINST.

End of the caution.

The database that has been upgraded is now in the ONLINE operational state.