PM33457: ReqPro slow performance with Oracle database

APAR status

• Closed as program error.

Error description

• Large views in ReqPro take a considerable amount of time to open
  when using the 'Retain Hierarchical Display' feature.
  Un-checking the 'Retain Hierarchical Display' setting on a view
  results in much better performance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Large views in ReqPro take a considerable amount of time to
  open when using the "Retain Hierarchical Display" feature.
  Un-checking the "Retain Hierarchical Display" setting on a
  view results in much better performance.
  

Problem conclusion

• A logic was added to improve the performance in all
  databases Rational RequisitePro supports except DB2.  In
  Oracle the creation of TmpLvl_xxxxx tables is avoided.
  

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

  REQUISITEPRO WI

• Fixed component ID

  5724G3900

Applicable component levels

• R700 PSN

     UP