PJ39765: LOWER FUNCTION IN SELECT STATEMENT DURING RUNNING CONTROL FLOW WILL CAUSE PERFORMANCE PROBLEM

APAR status

• Closed as program error.

Error description

• When using admin console in InfoSphere warehouse 9.7.1,
  performance of flow execution and monitor when including unit
  statistic operation is bad
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When using administration console, performance of flow       *
  * execution and monitor when including unit statistic          *
  * operation is bad                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Infosphere Warehouse V9.7.7                       *
  ****************************************************************
  

Problem conclusion

• This problem was first fixed in version 9.7 Fix Pack 1. At a
  minimum, this fixpack should be applied on the server(i.e.
  Administration Console).
  
  After applying this fix, the performance of flow execution and
  moditoring will be ok.
  

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

  DWE SQL WHSE TO

• Fixed component ID

  5724DWESQ

Applicable component levels

• R971 PSY

     UP