search cancel

Improve performance of On-line object tree build


Article ID: 53916


Updated On:


RC Compare for DB2 for z/OS



The object tree is used in an RCM session when creating or updating strategies. It contains only relationship information used to traverse from one object to another.

  • Occurs for Compares (target & source) and Migrations, but not Alters

  • Occurs ONCE per subsystem, per RCM session (unless the same subsystem is referenced multiple times, with other subsystems being referenced in between)

  • Is built only upon first Strategy Create or Strategy Update (per subsystem, per session)


These are some performance guidelines to improve online tree build performance:

  • VSAM Reads will help performance (pre DB2 v8 only)

  • ACM(Alternate Catalog Mapping) will help performance
    Note: VSAM Reads cannot be used in conjunction with ACM

  • Reorging the strategy tables will not boost performance of online tree build

  • Additional catalog indexes will not help performance of online tree build because where clauses are not used

  • FULLTREE yes/no does not affect the online tree build


Component: RCM