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 procedures in the DB2 installation manual.
  • 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. You can move the tables to a different table space after the installation is complete.
  • If you are reinstalling the software, be aware that data in your existing database is deleted. To preserve the data, either back up the existing database or save it under a different name.
  • After you create and configure your database, recycle the database. Then, stop and 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 Your Notes
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 installation will fail.

Be sure to install the correct version and patches. See the System Requirements for supported version information.

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