Upgrading your database

Before you can upgrade, you must ensure that your database meets the requirements for Sterling B2B Integrator. The database version must match exactly.

Microsoft SQL Server 2000 or 2005

If required, copy the Microsoft SQL Server 2000 or 2005 database to a supported SQL Server database version.

This is an optional procedure, and it is the customer's responsibility to complete it. (IBM Customer Support can not help with this procedure.)

Important: If you have upgraded your database to MS SQL 2016, you must ensure that the collation setting is set to SQL_Latin1_General_CP850_BIN before you upgrade Sterling B2B Integrator to v6.0. Sterling B2B Integrator requires SQL_Latin1_General_CP850_BIN as a collation setting. For more information, see https://www-01.ibm.com/support/docview.wss?uid=swg21996721.

Oracle

If required, update your Oracle database to a supported version.

If you plan to import an Oracle database, while upgrading to this version of Sterling B2B Integrator, you must import the database without the indexes.

For example, if you are using the Oracle import (imp) tool, you should use the INDEXES=N option. If you attempt upgrading to this version of Sterling B2B Integrator with indexes turned on, the upgrade will fail.

If you had created any custom indexes in Oracle database, add them after performing the upgrade as they are not imported.

Important: If you are using Oracle SSL authentication, you cannot install or upgrade Sterling B2B Integrator. You must roll back the SSL configuration to a Standard Oracle database connection before you install or upgrade Sterling B2B Integrator. This includes applying a Fix Pack for Sterling B2B Integrator.

DB2

To upgrade from DB2 9.5 or 9.7 to 10.1 or 10.5, you must make configuration changes. To upgrade from DB2 9.5 or 9.7 to 10.1 or 10.5, complete the following steps:
Attention: Back up all files before you change any settings.
  1. Copy your DB2 9.5 or 9.7 database content to DB2 10.1 or 10.5.
  2. Back up the database driver in the /<install_dir>/dbjar/jdbc/DB2/ directory and replace it with the DB2 10.1 or 10.5 version.
  3. Upgrade to Sterling B2B Integrator v6.0.
  4. Update the following sandbox.cfg file fields with your environment-specific parameters:
    DB_PASS=
DB_SCHEMA_OWNER=
DB_DRIVERS_VERSION=
YANTRA_DB_PORT=
DB_DATA=
DB_HOST=
YANTRA_DB_USER=
DB_PORT=
YANTRA_DB_PASS=
YANTRA_DB_DATA=
YANTRA_DB_HOST=
DB_DRIVERS=
DB_USER=

DB2_PORT=
DB2_USER=
DB2_PASS=
DB2_DATA=
DB2_HOST=
  5. Edit the following value in the activemq.xml file:
    activemq.xml: <value>jdbc:db2//DB_HOST:DB_PORT/DB_DATA</value>
  6. Run the setupfiles script.
  7. Run the deployer script.
  8. Start Sterling B2B Integrator.