Implementing Siebel Business Applications on DB2 for z/OS > About Siebel Table Partitioning > Example of Partitioning the S_ADDR_ORG Table >

Example of Definitions for Table Space Partitions

The example for the Tablespace object in Example of a Table Space Definition specifies 10 partitions; therefore, ten Tspart objects must be defined, as shown in the following example for objects 3644 through 3653).

[Object 3644]
Type = Tspart
Name = H0401504
PartNum = 1
...
[Object 3653]
Type = Tspart
Name = H0401504
PartNum = 10

Example of the DDL for the Partitioned Table Space

The storage control file definitions for the partitioned table space in the previous example result in the following output DDL statements:

CREATE TABLESPACE H0401504 IN D0059504 USING STOGROUP SYSDEFLT PRIQTY 48 SECQTY 1440 FREEPAGE 0 PCTFREE 17 LOCKPART YES DEFINE NO NUMPARTS 10 ( PART 1 USING STOGROUP SYSDEFLT ,
PART 2 USING STOGROUP SYSDEFLT ,
PART 3 USING STOGROUP SYSDEFLT ,
PART 4 USING STOGROUP SYSDEFLT ,
PART 5 USING STOGROUP SYSDEFLT ,
PART 6 USING STOGROUP SYSDEFLT ,
PART 7 USING STOGROUP SYSDEFLT ,
PART 8 USING STOGROUP SYSDEFLT ,
PART 9 USING STOGROUP SYSDEFLT ,
PART 10 USING STOGROUP SYSDEFLT ) BUFFERPOOL BP16K1 LOCKSIZE PAGE LOCKMAX 0 COMPRESS YES