Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390

Appendix D. DB2 customization jobs 145

CREATE TABLESPACE BBBBB060

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD005

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD006

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD007

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD008

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD009

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD010

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD011

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD012

146 Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD013

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD014

IN SIEBEL07

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB001

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB002

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB003

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB004

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB061

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB062

IN SIEBEL08

Appendix D. DB2 customization jobs 147

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE CCCCC001

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP16K1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD001

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD002

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD003

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD041

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD042

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD043

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD044

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

148 Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD045

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD046

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD047

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD048

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD049

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD050

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD051

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD052

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

Appendix D. DB2 customization jobs 149

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD053

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE DDDDD054

IN SIEBEL08

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB006

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB007

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB008

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB009

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB010

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;

CREATE TABLESPACE BBBBB011

IN SIEBEL09

SEGSIZE 32 USING STOGROUP STOGRP01

BUFFERPOOL BP1

LOCKSIZE PAGE; COMMIT;