how to upgrade from 7.6.0 (rpm) to 7.6.3

[Former Member]

Hi all,

what is the recommended path to upgrade an rpm installation (version 7.6.0) to the current release? I have not found any current rpm installation sets in the download area and the manual does not say anything about using SDBUPD on an rpm installation.

Thanks for the help...

Regards,

Arne

[Melanie · Accepted solution]

Hello Arne,

you cannot use SDBUPD directly if your first installation was done using the rpm packages.

Please try the following procedure:

1. Stop all databases (db_offline) and the x_server

2. remove the rpms <b>(database TST76 will be dropped! If you need this database, you should not execute these steps!!!)</b>:

rpm -e `rpm --last -qa | grep maxdb | sed s:
s.\*::`

3. Install the new software:

./SDBINST -profile Server -indep_data /var/opt/sdb/data -indep_prog /opt/sdb/programs -depend /opt/sdb/7603 -o sdb -g sdba

For each database perform the following steps:

4. register the database with the new software:

/opt/sdb/programs/bin/dbmcli -R /opt/sdb/7603 db_create <database name> <dbm user>,<passwd>

5. DBM connect:

/opt/sdb/programs/bin/dbmcli -d <database name> -u <dbm user>,<passwd>

6. start the database (execute all commands in one dbmcli session):

param_checkall

db_online

load_systab

It is important, that you use the same directories and the same user/group (sdb:sdba) for the new software installation as for the rpm packages.

It won't hurt to create a backup of your database before you start the upgrade...

Best regards,

Melanie

[Melanie · Accepted solution]

Sorry, there is a small error in the last description, step 2.

Correct is:

rpm -e `rpm --last -qa | grep maxdb | sed s:
\s.
*::`

Best regards,

Melanie

[former_member229109]

Hello Arne,

-> You have already installed the database instance of the version 7.6 of the MaxDB

software, you could use the SDBUPD tool to upgrade from 7.6.0 version to

7.6.3 version.

As of Version 7.6, you can alternatively call SDBSETUP.

How to use SDBSETUP is described in SAP Note 1092397, for example.

-> Are you SAP customer?

If you are SAP customer, please see the SAP Note No. 735598.

The SAP Note 972785 describes the changed version numbering as of MaxDB Version 7.6.

-> The SAP Note No. 735598 does not apply to liveCache.

Please check if you have the liveCache instance, then please follow the SAP note 875662.

< Please check the database parameter in the knldiag file, for example,

if INSTANCE_TYPE=LVC => you have the liveCache instance >

-> Please see the documentation at "Using the Installation Manager" < SDBSETUP > at

http://maxdb.sap.com/currentdoc/74/df234239f75733e10000000a155106/content.htm

< And all MAXDB users could review the documentations to install the MAXDB at

https://www.sdn.sap.com/irj/sdn/maxdb

-> The Complete MaxDB Documentation Set

-> Installation -> Installation Manual ->

Installation, Upgrade and Uninstallation on the Command Line

or

Upgrading Database Instances and Their Server Software >

Thank you and best regards, Natalia Khlopina