Configuring the DB2 database

Before you install Sterling B2B Integrator with the DB2® database, you must configure the database.

Before you begin

  • If you do not have DB2 installed, follow the DB2 installation procedure in the DB2 documentation.
  • The installation script creates tables and indexes. Certain tables require a page size of 32 KB. You must have a temporary table space to accommodate such tables. DB2 automatically places tables and indexes in the available table spaces.
    Note: After the installation is complete, you can move the tables to a different table space.
  • If you are reinstalling the software, be aware that data in your existing database is deleted. To preserve the data, either back-up your existing database or save it with a different name.
  • After you create and configure your database, recycle the database. Restart the database to apply the changes.

Configuring DB2

Use the following checklist to configure DB2 for Sterling B2B Integrator.

Table 1. Checklist to configure DB2
Item DB2 Database Configuration Checklist
1 Create the database.
Refer to the DB2 documentation on creating the database, including creating a schema repository, login, and table space.
Important: In V5.2.6.2 or later you must ensure that all tablespaces used by Sterling B2B Integrator tables have a minimum page size of 16K. Otherwise, the installation will fail.

Ensure to install the correct version and patches. See the Software Product Compatibility Reports for supported version information.

2 Review the DB2 parameters.
3 Ensure that the DB2 user privileges are set.
4 Install the JDBC drivers for DB2.