Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring IBM DB2 UDB for Siebel Applications >
Guidelines for Overriding DB2 UDB Default Table Spaces for Database Objects
Siebel Systems provides the option of overriding the default storage parameters for the table spaces in which specific tables or indexes are created. You created these table spaces using the instructions under Guidelines for Creating DB2 UDB Table Spaces. To override these defaults, edit the ddl.ctl file located in the dbsrvr/DB2UDB 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 they default to the parameters of the table spaces in which they are created. However, the Table Space parameter only works under the following conditions:
- The table does not yet exist (for example, when you are performing a new database installation).
- The table needs to be rebuilt. In other words, there are schema changes made to the table such that an
ALTER TABLE command is not sufficient to implement the schema changes, requiring that the Siebel application drop and re-create the table.
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
|