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

Table Spaces

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

Among Siebel templates that contain multiple tables per table space, only one 32-KB table space exists within the Siebel database schema.

NOTE:  Users 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 241]
Type = Tablespace
Name = H0001004
Database = SIEBDB01
LockSize = Page
Bufferpool = BP1
Define = No
Partitions = 0

This Tablespace object translates into the following DDL output:

CREATE TABLESPACE H0001004 IN SIEBDB01
USING STOGROUP SYSDEFLT
PRIQTY 48 SECQTY 1440 FREEPAGE 4 PCTFREE 30
DEFINE NO
SEGSIZE 32
BUFFERPOOL BP1 LOCKSIZE PAGE LOCKMAX 0 COMPRESS NO /

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

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


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003