Siebel Assignment Manager Administration Guide > Running Assignment Manager >

About Tuning Assignment Manager for Performance in a DB2 Deployment

If you are using DB2, for performance reasons, you should periodically execute the REORG and update statistics utilities against all applicable tables for the assignment objects that you use. For example, to enhance Assignment Manager performance before running batch or dynamic assignment for contact territory realignment (assuming you are using the preconfigured Contact assignment object), you should 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_POST 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 UDB for z/OS and the Siebel Installation Guide for the operating system you are using.