Implementing Siebel Business Applications on DB2 UDB for z/OS > Understanding Siebel Partitioning >
About Prepartitioned Siebel Tables
Table 10 shows the partitioned tables provided in the Siebel 8.0 storage control file templates. The database tables listed in Table 10 represent partitioned Core product tables; seven exceptions are identified as Siebel Industry Applications (SIA) product tables. For each table in Table 10, the partitioning key columns for the table are listed, as is the recommended clustering index for the table. A partitioning index is defined for three of the partitioned tables (S_CONTACT, S_OPTY and S_ORG_EXT); the name of the index is listed for these tables. When determining the partitioning strategy for your implementation, you must assess whether the partitioning key columns and recommended clustering indexes specified for the prepartitioned tables are appropriate for your environment. For example, in assessing the most appropriate partitioning column to use for intersection tables, take into account the relationship of candidate partitioning columns to their respective parent tables. Additionally, if multiple organizations are defined in your Siebel application, the BU_ID column might be the most appropriate partitioning column for a table. For information on customizing partitioned tables, see Customizing a Partitioned Table.
Table 10. Prepartitioned Siebel Tables with Physical Columns
|
|
Recommended Clustering Index |
S_ACT_EMP
|
PARTITION_COLUMN
|
S_ACT_EMP_M1 |
S_ADDR_ORG
|
PARTITION_COLUMN
|
S_ADDR_ORG_U1
|
S_ADDR_PER
|
PARTITION_COLUMN
|
S_ADDR_PER_U1
|
S_APPLD_CVRG
Siebel Industry Applications (SIA) table |
PARTITION_COLUMN
|
S_APPLD_CVRG_U1
|
S_ASSET
|
PARTITION_COLUMN
|
S_ASSET_U1 (ASSET_NUM, PROD_ID, REV_NUM, BU_ID, CONFLICT_ID) |
S_ASSET_CON
|
PARTITION_COLUMN
|
S_ASSET_CON_U1 (ASSET_ID, CONTACT_ID, RELATION_TYPE_CD, CONFLICT_ID)
|
S_ASSET_POSTN
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_ASSET_POSTN_M1
|
S_COMMUNICATION
|
PARTITION_COLUMN
|
S_COMMUNICATION_U1
|
S_CONTACT
A partitioning index, S_CONTACT_M12, is defined for this table. |
LAST_NAME
NOTE: If multiple organizations are defined in your Siebel application, the BU_ID column might be a more effective partitioning key than the LAST_NAME column. In this case, cluster on the S_CONTACT_M14 index (BU_ID, LAST_NAME, FST_NAME, PRIV_FLG).
|
S_CONTACT_M12 (LAST_NAME, FST_NAME, MID_NAME, PRIV_FLG, ALIAS_NAME )
|
S_EVT_ACT
|
PARTITION_COLUMN
|
S_EVT_ACT_P1
|
S_EXP_ITEM
|
PARTITION_COLUMN
|
S_EXP_ITEM_U1
|
S_FN_ACCNT_TXN
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_FN_ACCNT_TXN_U1
|
S_FNCVRG_ELMNTS
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_FNCVRG_ELMNTS_U1
|
S_INS_CLAIM
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_INS_CLAIM_U1
|
S_INS_ITEM
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_INS_ITEM_U1
|
S_INSCLM_ELMNT
Siebel Industry Applications (SIA) table
|
PARTITION_COLUMN
|
S_INSCLM_ELMNT_U1
|
S_OPTY
A partitioning index, S_OPTY_U1, is defined for this table. |
NAME
NOTE: If multiple organizations are defined in your Siebel application, the BU_ID column might be a more effective partitioning key than the NAME column. In this case, cluster on the BU_ID, NAME columns.
|
S_OPTY_U1 (NAME, PR_DEPT_OU_ID, BU_ID, CONFLICT_ID)
|
S_OPTY_POSTN
|
PARTITION_COLUMN
|
S_OPTY_POSTN_U1 (OPTY_ID, POSITION_ID, CONFLICT_ID)
|
S_ORG_EXT
A partitioning index, S_ORG_EXT_U1, is defined for this table. |
NAME
|
S_ORG_EXT_U1 (NAME, LOC, BU_ID, CONFLICT_ID)
|
S_PARTY
|
PARTITION_COLUMN
|
S_PARTY_P1
|
S_PARTY_REL
|
PARTITION_COLUMN
|
S_PARTY_REL_U1
|
S_POSTN_CON
|
PARTITION_COLUMN
|
S_POSTN_CON_M1 (POSTN_ID, CON_LAST_NAME, CON_FST_NAME)
NOTE: If the S_POSTN_CON table is not implemented as partitioned, cluster on either the POSTN_ID or the CON_ID column, depending on the one-to-many relationship of each column to its parent table.
|
S_REVN
|
PARTITION_COLUMN
|
S_REVN_U1 (REVN_ITEM_NUM, BU_ID, CONFLICT_ID)
|
S_SRV_REQ
|
PARTITION_COLUMN
|
S_SRV_REQ_U1 (SR_NUM, BU_ID, CONFLICT_ID)
|
|