Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring MS SQL Server for Siebel Applications >

Guidelines for Overriding MS SQL Server Default Table Spaces for Database Objects

Siebel Systems provides the option of overriding the default storage parameters for the table spaces you create to hold specific tables or indexes. To do this, edit the ddl.ctl file located in the dbsrvr\MSSQL directory.

NOTE:  The ddl.ctl file should be modified only by a qualified DBA.

For each Siebel table, you can specify a table space by using the Table Space parameter. In the following example, the table space for the table S_APP_VIEW is set to DATA1. As provided by Siebel Systems, the .ctl file does not set storage parameters for the objects it creates, so objects default to the parameters of the table spaces in which they are created.

As shown in the example that follows, you can use the Table Space parameter to set storage parameters for specific tables.

[Object 219]
Type = Table
Name = S_APP_VIEW
Column 1 = ROW_ID VARCHAR(15) NOTNULL
Column 2 = CREATED TIMESTAMP NOTNULL DEFAULT %NOW%
Column 3 = CREATED_BY VARCHAR(15) NOTNULL
Column 4 = LAST UPD TIMESTAMP NOTNULL DEFAULT %NOW%
Column 5 = LAST_UPD_BY VARCHAR(15) NOTNULL
Column 6 = DCKING_NUM NUMERIC(22,7) DEFAULT 0
Column 7 = MODIFICATION_NUM NUMERIC(10,0) NOTNULL DEFAULT 0
Column 8 = CONFLICT_ID VARCHAR(15) NOTNULL DEFAULT '0'
Column 9 = NAME VARCHAR(50) NOTNULL
Column 10 = DESC_TEXT VARCHAR(255)
Column 11 = LOCAL_ACCESS_FLG CHAR(1)
Table Space = data1

For an example of overriding the defaults for specific tables and indexes, see Guidelines for Overriding DB2 UDB Default Table Spaces for Database Objects.