About Tuning Siebel Assignment Manager for Performance in an IBM DB2 Deployment

If you are using IBM DB2, then, for performance reasons, periodically execute the REORG and update statistics utilities against all applicable tables for the assignment objects that you use.

For example, to enhance Siebel Assignment Manager performance before running batch or dynamic assignment for contact territory realignment (assuming that you are using the preconfigured Contact assignment object), execute REORG and update statistics against the related tables, such as the S_CON_TERR and S_POSTN_CON tables.

For the Account assignment object, consider evaluating the S_ORG_TERR and S_ACCNT_POSTN tables; and for the Opportunity assignment object, consider evaluating the S_OPTY_TERR and S_OPTY_POSTN tables; and so on. For applicable tables for other assignment objects (planned or in use), view the assignment object properties for those objects using Siebel Tools.

For more information about the REORG and update statistics utilities, see Implementing Siebel Business Applications on DB2 for z/OS and the Siebel Installation Guide for the operating system you are using.