Implementing Siebel Business Applications on DB2 UDB for z/OS > Configuring the Database Layout > About Siebel Objects >

Table Space Objects in Storage Control Files

Siebel tables are created in one of four table space sizes, 4 KB, 8KB, 16 KB, and 32 KB. Most tables are defined within a 4-KB table space.

NOTE:  You can create new table spaces, and you can regroup tables as required for your enterprise.

The following example illustrates what the segmented Tablespace object for the Siebel repository looks like in the storage control file.

[Object 4340]
Type = Tablespace
Name = H1004000
Database = SIDB1004
LockSize = Page
Bufferpool = BP1
Define = No
Partitions = 0

This Tablespace object translates into the following DDL output:

CREATE TABLESPACE H1004000 IN SIDB1004
USING STOGROUP SYSDEFLT
PRIQTY 48 SECQTY 1440 FREEPAGE 0 PCTFREE 17
DEFINE NO
SEGSIZE 32
BUFFERPOOL BP1 LOCKSIZE PAGE LOCKMAX 0 COMPRESS YES /

NOTE:  If you compare the input and the output, you can see that there are more options in the DDL output. These additional options occur because some values, such as FREEPAGE and PCTFREE, are taken from the default values.

Object numbering can change when you perform a storage control file extract. Therefore, object numbering can be different from one storage control file to another (except for default storage objects, for which numbering remains consistent).