Implementing Siebel Business Applications on DB2 UDB for z/OS > Preparing for Implementation on the DB2 Host >
Planning the Distribution of Database Objects
Be sure that you properly distribute the following types of database objects:
- Database log or archive files
- Temporary work space used by the database
- Tables and indexes
- Partitions
- CHAR large objects (CLOBs)
In most implementations, the Siebel tables listed in Table 8 and their corresponding indexes are either the most commonly used tables or the largest tables. For example, the tables S_EVT_ACT, S_PARTY, and S_ORG_EXT are large in all enterprise-level deployments of Siebel Business Applications. These tables and their indexes should be separated across devices. As a general rule, indexes should be on different physical devices to the tables for which they are created.
Table 8. Most Frequently Used and Largest Siebel Tables
|
S_ACCNT_POSTN |
S_CONTACT_FNX |
S_FN_ACCNT2_FNX |
S_ORG_EXT_X |
S_ACT_CONTACT |
S_CONTACT_FNXM |
S_INVC_ITM_DTL |
S_ORG_EXT_XM |
S_ACT_EMP |
S_CONTACT_X |
S_LIST_COL_INTL |
S_ORG_TERR |
S_ADDR_ORG |
S_DOCK_TXN_LOG |
S_NOTE_ACCNT |
S_PARTY |
S_ADDR_PER |
S_DOCK_TXN_SET |
S_NOTE_DEFECT |
S_PARTY_PER |
S_ASSET |
S_ETL_R_IMAGE |
S_NOTE_OPTY |
S_POSTN_CON |
S_ASSET_CON |
S_ETL_VR_IMAGE |
S_OPTY_ORG |
S_PRSP_CONTACT |
S_ASSET_POSTN |
S_EVT_ACT |
S_OPTY_ORG_CMPT |
S_QUOTE_ITEM |
S_ASSET_REL |
S_EVT_ACT_FNX |
S_OPTY_POSTN |
S_SLSCRDT_VAL |
S_CAMP_CON |
S_EVT_ACT_X |
S_OPTY_TERR |
S_SRV_ACT |
S_COMMUNICATION |
S_EVT_MAIL |
S_ORG_BU |
S_TMSHT |
S_CON_ADDR |
S_EXP_ITEM |
S_ORG_EXT |
S_TMSHT_APPR |
S_CONTACT |
S_EXP_RPT_APPR |
S_ORG_EXT_FNX |
S_TMSHT_ITEM |
S_CONTACT_BU |
S_FN_ACCNT1_FNX |
S_ORG_EXT_FNXM |
S_TMSHT_LN |
|