Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and 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 7 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 eBusiness Applications. These tables and their indexes should be separated across devices. As a general rule, indexes should be on different physical devices from the tables for which they are created.

Table 7.  Most Frequently Used and Largest Siebel Tables

Table Names
S_ACCNT_CHRCTR	S_CON_CHRCTR	S_CYC_CNT_ASSET
S_ACCNT_CO_MSTR	S_CON_TERR	S_DNB_CON_MRC
S_ACCNT_POSTN	S_CRSE_TSTRUN	S_DNB_ORG
S_ADDR_ORG	S_CRSE_TSTRUN_A	S_DNB_ORG_SIC
S_ADDR_PER	S_CS_RUN	S_DNB_UPDATE
S_ASSET	S_CS_RUN_ANSWR	S_DOCK_INIT_ITEM
S_CALL_LST_CON	S_CTLGCAT_PATH	S_DOCK_TXN_LOG
S_DOCK_TXN_LOGT	S_IC_TXN_POSTN	S_INVC_ITM_DTL
S_DOCK_TXN_SET	S_INVOICE	S_INVLOC_ROLLUP
S_DOCK_TXN_SETT	S_INVOICE_ITEM	S_POST_CON
S_ESCL_ACTN_REQ	S_INV_LGR_ENTRY	S_PROC_REQ
S_ESCL_LOG	S_OPTY_POSTN	S_PROD_BASELINE
S_ESCL_REQ	S_OPTY_PROD	S_PROD_CONSUME
S_EVT_ACT	S_OPTY_TERR	S_PROD_SHIPMENT
S_EXP_ITEM	S_OPTY_POSTN	S_PROD_TARGET
S_EXP_RPT	S_ORG_EXT	S_QUOTE_ITEM
S_EXP_RPT_APPR	S_ORG_TERR	S_SRM_REPLY
S_IC_CALC	S_PARTY	S_SRM_REQUEST
S_IC_CALC_IT	S_PARTY_PER	S_SRM_REQ_PARAM
S_IC_CMPNT_EARN	S_PARTY_REL	S_SRV_REQ
S_IC_TXN	S_PARTY_RPT_REL
S_IC_TXN_IT	S_POSTN_CON

Bookshelf Home | Contents | Index | Search | PDF