Procedure documentationCase 2: Downgrading Dependent Software Locate this document in the navigation structure

 

Databases already exist that refer to the higher software version. You want to downgrade the software exclusively used by the database (dependent software).

Procedure

Downgrade at Build Level

If you want to perform the downgrade at build level only, in most cases there will be no incompatibilities between the databases of the higher version and the software of the lower version.

However, there might have been implemented changes between the affected versions, which do not not guarantee that the downgrade will be successful. If the database cannot be transferred into the ONLINE operational state after you have carried out the steps below, proceed as described in the section “Downgrade with Change of Version”.

To start a downgrade at build level, carry out the steps below for each of the affected databases:

Action

Command

1.

Switch to a Command Prompt, call Database Manager CLI, log on as a DBM operator and connect to the database.

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

2.

Delete the database registration.

>db_drop WITHOUTFILES

3.

Exit Database Manager CLI.

>exit | release | quit | bye

4.

Uninstall at least the database kernel and the required software component(s) of the higher version.

>sdbuninst -package "Database Kernel" [, <package_name2>...]

5.

Install the desired installation profile of the lower version (at least the Server installation profile).

>sdbinst -profile Server [, <inst_profile2>...]

6.

Re-register the database. Enter the name and DBM operator of the old database, plus the path of the newly-installed lower software version.

>dbmcli -R <dependent_path> db_create <database_name> <dbm_operator>,<dbm_operator_password>

Downgrade with Change of Version

If the downgrade implies a change of version of the database software (minor or major version), proceed as follows:

Action

Command

1.

Open a Command Prompt, call Database Manager CLI, log on as a DBM operator and connect to the database.

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

2.

Delete the database.

>db_drop

3.

Exit Database Manager CLI.

>exit | release | quit | bye

4.

Uninstall at least the database kernel and the required software component(s) of the higher version.

>sdbuninst -package "Database Kernel" [, <package_name2>...]

5.

Install the desired installation profile of the lower version (at least the Server installation profile).

>sdbinst -profile Server [, <inst_profile2>...]

6.

Create a new database using the parameter file from a backup.

See Database Manager CLI Tutorial, Copying a Parameter File from a Data Backup

7.

Import the data backup performed before starting the update process into the newly created database.

See Database Manager CLI Tutorial, Creating a Database Copy (Importing a Data Backup into Another Database