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;

Create Oracle Schema for Sterling Selling and Fulfillment Suite 8.0, 8.1, 8.5, 9.0, 9.1, and 9.2

Refer to create DB2 schema for Sterling Commerce for creating a DB2 schema for Sterling Selling and Fulfillment Suite.

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

Here is the schema creation script that I have used since Sterling 8.0. It should help you to get started in creating your Sterling schema.

-- Create the table space so Sterling schema will be on its own schema

CREATE TABLESPACE "SMCFS_92_TS"

NOLOGGING

DATAFILE '/u02/oradata/SMCFS_92_TS.DBF' SIZE 200M AUTOEXTEND ON

ONLINE;

-- Create the user/schema for Sterling

CREATE USER "SMCFS_92_USER" IDENTIFIED BY "SMCFS_92_PASSWORD"

DEFAULT TABLESPACE "SMCFS_92_TS"

TEMPORARY TABLESPACE "TEMP"

PROFILE "DEFAULT";

GRANT "CONNECT" TO "SMCFS_92_USER";

GRANT "RESOURCE" TO "SMCFS_92_USER";

ALTER USER "SMCFS_92_USER" DEFAULT ROLE ALL;

GRANT CREATE TYPE TO "SMCFS_92_USER";

GRANT CREATE ANY PROCEDURE TO "SMCFS_92_USER";

GRANT CREATE PUBLIC SYNONYM TO "SMCFS_92_USER";

GRANT CREATE SYNONYM TO "SMCFS_92_USER";

GRANT CREATE ROLE TO "SMCFS_92_USER";

GRANT CREATE SEQUENCE TO "SMCFS_92_USER";

GRANT CREATE TRIGGER TO "SMCFS_92_USER";

GRANT CREATE VIEW TO "SMCFS_92_USER";

GRANT CREATE MATERIALIZED VIEW TO "SMCFS_92_USER";