Bookshelf Home | Contents | Index | PDF |
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 PartitionsThe 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] Example of the DDL for the Partitioned Table SpaceThe 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 , |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |