Upgrade Guide for DB2 UDB for z/OS > Performing the Siebel Tools Repository Merge >

About Reorganizing Tables Before the Repository Merge

Upgrades: All upgrades.

Environments: Development environment only.

This topic is part of an upgrade process. See How to Perform the Upgrade.

During the repository merge process, objects from four separate repositories are read and compared. Because this is a memory-intensive process, it is recommended that you execute the REORG utility on certain tables before performing the repository merge to improve performance. The following tables receive a large number of inserts during each repository import; running REORGs on each table's ROW_ID column will significantly increase the performance of the merge.

• S_APPLET_METH_MI
• S_APPL_WEB_TMPL
• S_APPL_WTMPL_IT
• S_BOCOMP
• S_BUSCOMP_UPROP
• S_COLUMN
• S_CONTROL_INTL
• S_CONTROL_UPROP
• S_DDOWN_OBJECT
• S_EIM_FK_MAPCOL
• S_FIELD
• S_INDEX
• S_INDEX_COLUMN
• S_INTFLD_UPROP
• S_INT_CKEY_FLD
• S_INT_COMP
• S_INT_FIELD
• S_JOIN
• S_JOIN_SPEC
• S_LIST
• S_LIST_COLUMN
• S_PICKMAP
• S_SCREEN_VIEW
• S_UK_ATTJOIN
• S_LIST_COL_INTL
• S_USER_KEY_ATT
• S_VIEW_WTMPL_IT
• S_CONTROL
• S_CONTROL
• S_EIM_ATT_MAP