PI28242: IMPROVE DCC PERFORMANCE WITH ORACLE (WI 331422)

Rational Insight Fix Pack 6 (1.1.1.6) for 1.1.1
Rational Insight Fix Pack 7 (1.1.1.7) for 1.1.1

APAR status

• Closed as program error.

Error description

• Attempts to load data from Rational Quality Manager (RQM) using
  the Data Collection Component (DCC) results in poor performance
  when using Oracle as the Data Warehouse.  Performance with SQL
  Server and DB2 are not impacted.
  
  Refer to the following defect work item for details:
  
  https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.Wo
  rkItem/331422
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Customers using RRDI before 5.0.2                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Need to improve DCC performance with oracle                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Defect Resolution:
  Team made a number of fixes to improve Oracle performance.
  

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

  RATL COMMON REP

• Fixed component ID

  RATLRCR00

Applicable component levels

• R502 PSY

     UP