Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Configuring the Database Layout > About Siebel Objects >
About Table Spaces in Storage Control Files
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.
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.
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 4 PCTFREE 30
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
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).