Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Server Installation Guide for Microsoft Windows > Creating the Microsoft SQL Server Database > Creating the Database >
Overriding Default Storage Parameters
Siebel Systems provides the option of overriding the default storage parameters, such as the filegroups you create to hold specific tables or indexes. To do this, edit the
ddl.ctl
file located in thedbsrvr\
DBSRVR_PLATFORM
directory.
NOTE: The
ddl.ctl
file should be modified only by a qualified DBA.For each Siebel table, you can specify a filegroup by using the
Table
Space
parameter. In the following example, the filegroup for the tableS_APP_VIEW
is set toDATA1.
As provided by Siebel, the.ctl
file does not set storage parameters for the objects it creates, so they will default to the parameters of the filegroups in which they are created.As shown in the example below, 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
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |