RS03620: SLOW TO BROWSE BRANCHES WITH MANY RULE PACKAGES

Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.9.2.1: Interim Fix 34
Operational Decision Manager V8.9.1.0: Interim Fix 42
Operational Decision Manager V8.9.1.0: Interim Fix 41

APAR status

• Closed as program error.

Error description

• Browsing a branch in Decision Center or performing a merge is
  very slow. This can be more significant with PostgresSQ: or MS
  SQLServer databases.
  

Local fix

• create 3 indexes:
  
  CREATE INDEX <dbSchema>.BSLNLFTRGTIDX ON
  <dbSchema>.BSLNLFTRGT (CONTAINER, TYPE, LFT,
   RGT) ;
  CREATE
  INDEX <dbSchema>.BSLNLFTRGTPARENTIDX ON <dbSchema>.BSLNLFTRGT
  (CONTAINER, LFT,
   RGT, PARENT) ;
  CREATE INDEX
  <dbSchema>.BSLNLFTRGTTYPEIDX ON <dbSchema>.BSLNLFTRGT (TYPE)
  ;
  
  Adapt case for tables and columns name according to your
  database.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users browsing branches with many packages or performing a   *
  * merge.                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running the merge operation using a very large repository    *
  * performs poorly.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• An index has been added.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R892 PSY

     UP