Improve performance of On-line object tree build

Document ID : KB000053916
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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)

Solution:

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