Migrating the DBB server

If you are upgrading the DBB server from a previous release, the configuration from the old server must be merged into the new server configuration and the database must be migrated before starting the new server.

Procedure

1. Stop the DBB server:
   wlp/bin/server stop dbb

2. Rename the current DBB server directory:
   mv wlp wlp.old

3. Install the new version of the DBB server:
   tar -zxvf dbb-server-<release>.tar.gz

4. Review the server configuration changes that were made to the original installation. Changes can include ports and user registry customizations and database configurations.
   Note: Database and user registry configurations in 1.0.x are in or included in server.xml. Starting in 1.1.x, the database and user registry configuration is located in wlp/usr/servers/dbb/configDropins/overrides. If you migrate from 1.0.x to 1.1.x, either remove the configuration files in overrides or move the configurations from server.xml to the respective file in overrrides.

   Make sure that the following server configuration changes were made:

   • The jdbcdriver and datasource tags must have been copied from the old server.xml file to the new databaseConfig.xml file.
   • The ADMIN user ID must have been replaced in the new server.xml file with the web.admin ID from the dbb.properties file.
   • The content of the dbb.properties file must have been copied from the old configuration to the new dbb.properties file.
   • The Lightweight Directory Access Protoco (LDAP) must have been configured again, based on the information from the old server.xml and ldapUserRegistry.xml.

5. Merge the configuration changes into the new installation.

6. Back up the current database by following established and verified procedures for your database. For example, for distributed Db2, use the backup command to backup your database.

7. Run the appropriate upgrade script located in /wlp/usr/servers/dbb/DDL. For example, for distributed Db2:
   db2 connect to DBB; db2 -stvf /path/to/install/wlp/usr/servers/dbb/DDL/upgrade_DB2_1.1.1.sql; db2 disconnect DBB
   Notes:

   • Not every version has its corresponding upgrade script. Check directory /wlp/usr/servers/dbb/DDL for all the available upgrade scripts.
   • You must run all the upgrade scripts, if they exist, between your currently installed version up to and including the target version.
   • The database must be in sync with the code. Therefore, failure to run all the upgrade scripts that apply will cause the server to terminate with an error that specifies which table is out of sync.

8. Review the output and verify that all the database commands run successfully.

9. If it is necessary to roll back changes to the database, restore the database from the backup. For distributed Db2, use the restore command to restore the backup to the database.

10. Start the DBB server:
    wlp/bin/server start dbb