Create DB2 Schema for Sterling Commerce Selling and Fulfillment Suite 8.5, 9.0, 9.2, and 9.2.1

Refer to Create Oracle Schema for Sterling Commerce for creating Oracle Schema.

Refer to Install Sterling 9.2 and 9.2.1 for Sterling 9.2 and 9.2.1 installation.

I have been using the following to create a DB2 database and user for Sterling Commerce for development purpose. It should help you in getting your development schema starts in DB2.

Connect to the DB2 instance and issue the following commands:

CREATE DATABASE SCMFS_85 AUTOMATIC STORAGE YES ON '/home/db2inst1' DBPATH ON '/home/db2inst1' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 32768;

CONNECT TO SCMFS_85;

CREATE REGULAR TABLESPACE SCMFS_85_TS PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 12.67 PREFETCHSIZE 16 TRANSFERRATE 0.18 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY OFF;

COMMENT ON TABLESPACE SCMFS_85_TS IS 'SMCFS 85 Tablespace';

CONNECT RESET;

CONNECT TO SCMFS_85;

GRANT CREATETAB,BINDADD,CONNECT ON DATABASE TO USER SMCFS_85_USER;

GRANT USE OF TABLESPACE SCMFS_85_TS TO USER SCMFS_85_USER;

CONNECT RESET;