How to use hdbsetup to upgrade multiple non-default databases?
search cancel

How to use hdbsetup to upgrade multiple non-default databases?


Article ID: 20591


Updated On:


CA Harvest Software Change Manager - OpenMake Meister



If SCM broker is setup for multiple server/database instances, with HBroker.arg file looks like below:

 //Default Version: Broker       
 -dirserver=/home/ scm-d/bin 
 // Version: Broker/version1
 // Version: Broker/version2

To upgrade this SCM broker instance, all three SCM server databases need to be upgraded. (default database, version1 database and version2 database). However, hdbsetup seems only able to recognize the default database DSN, therefore it only upgrades one database.


Hdbsetup has a hidden option "-d HomeDirPath". This -d option together with -UR ( upgrade repository) option can upgrade the other two non-default databases. Using the above HBroker.arg file as reference, below is syntax example for hdbsetup -d option:

 $hdbsetup -ur -d /home/scm-d/version1
 $hdbsetup -ur -d /home/scm-d/version2

The above 2 commands will upgrade the version1 and version2 database separately.

With the -d option specified, hdbsetup will copy all the required files ( HServer.arg, hsvr.dfo etc.) to $CA_SCM_HOME for the upgrade. Then after the upgrade is completed, it will delete all of them from $CA_SCM_HOME directory.


Release: SCMNCR99000-12.1-Harvest-Software Change Manager-Named User-Competitive Replacem