Bookshelf Home | Contents | Index | PDF |
Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an IBM DB2 Database for Siebel Business Applications > Guidelines for Managing IBM DB2 FragmentationNo strict guidelines can be offered as to which tables and indexes might be fragmented, because of the variety in application and customer operation variables at any given customer site. However, DBAs must pay attention to the status of large or heavily used tables, because fragmentation of these tables can affect performance significantly. For a list of these Siebel tables, see Siebel Deployment Planning Guide. NOTE: Do not reorganize S_ESCL_LOG, S_DOCK_INIT_ITEM, S_ESCL_ACTN_REQ, S_APSRVR_REQ, and all tables named S_DOCK_INITM_%% (in this table name, % is a digit), because these tables are defined to be in append mode. This topic is part of Configuring an IBM DB2 Database for Siebel Business Applications. Use the following strategy to manage table fragmentation:
|
Siebel Installation Guide for UNIX | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |