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.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |