Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an IBM DB2 Database for Siebel Business Applications >

Guidelines for Overriding IBM DB2 Default Tablespaces for Database Objects

Siebel Business Applications provide the option of overriding the default storage parameters for the tablespaces in which specific tables or indexes are created. You created these tablespaces by using the instructions in Guidelines for Creating IBM DB2 Tablespaces. To override these defaults, edit the ddl.ctl file located in the DBSRVR_ROOT/DB2UDB directory.

NOTE:  The ddl.ctl file must not be modified except by a qualified DBA.

For each Siebel table, you can specify a tablespace by using the Table Space parameter. In the following example, the tablespace for the table S_APP_VIEW is set to DATA1.

As provided, the .ctl file does not set storage parameters for the objects it creates, so they default to the parameter settings of the tablespaces in which they are created. However, the Table Space parameter works only under the following conditions:

• When the table does not yet exist (for example, when you are performing a new database installation).
• When the table must be rebuilt. In other words, when schema changes are made to the table such that an ALTER TABLE command is insufficient to implement the schema changes. In this case, the table must be dropped and re-created.

This topic is part of Configuring an IBM DB2 Database for Siebel Business Applications.

As shown in the following example, 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

The following example illustrates how to override the defaults for specific tables and indexes:

[Object 7135]
Type = Table
Name = S_EVT_ACT
Group = Activity-1
Append Mode = Yes
Column 1 = ROW_ID WVARCHAR(15) NOTNULL
Column 2 = CREATED TIMESTAMP NOTNULL DEFAULT %NOW%
Column 3 = CREATED_BY WVARCHAR(15) NOTNULL
Column 4 = LAST_UPD TIMESTAMP NOTNULL DEFAULT %NOW%
Column 5 = LAST_UPD_BY WVARCHAR(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 WVARCHAR(15) NOTNULL DEFAULT '0'
Column 9 = ACTIVITY_UID WVARCHAR(30) NOTNULL DEFAULT 'x'
...
Column 166 = TODO_CD WVARCHAR(30)
Column 167 = USER_MSG_ID WVARCHAR(15)
Column 168 = WC_START_VIEW WVARCHAR(250)
Column 169 = WC_TYPE_CD WVARCHAR(30)

[Object 7136]
Type = Index
Name = S_EVT_ACT_F1
Table = S_EVT_ACT
Column 1 = CON_PRDINT_ID ASC
Index Space = S_EVT_ACT_TBS_IDX

[Object 7137]
Type = Index
Name = S_EVT_ACT_F10
Table = S_EVT_ACT
Allow Reverse Scans = Yes
Column 1 = TARGET_OU_ID ASC
Column 2 = APPT_START_DT DESC
Column 3 = ROW_ID ASC

[Object 7138]
Type = Index
Name = S_EVT_ACT_F11
Table = S_EVT_ACT
Column 1 = PAR_EVT_ID ASC
Index Space = S_EVT_ACT_TBS_IDX