JR46587: Improve process portal inbox Query performance via concatenation optimization for authorization lobes on db2 z/OS

Download Version 8.0.1 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• Executing stress tests with BPM 8.0.1.1 the mainframe partition
  hosting DB/2 showed a higher consumption of CPU and memory than
  we expected limiting the number of simultaneous users.
  Running concurrent logins to process portal for a high number of
  users, performance of the inbox query turns out to generate
  significant CPU load and to be a response time bottleneck.
  

Local fix

• n/a
  

Problem summary

• Problem Description:
  The use-concatenation-optimization-for-authorization-lobes flag
  was disabled due to incompatibility with DB2 on z/OS. This
  incompatibility no longer exists, so the flag is re-enabled in
  this APAR. The flag may influence performance of the process
  search engine.
  
  Problem Summary:
  The use-concatenation-optimization-for-authorization-lobes flag
  was disabled due to incompatibility with DB2 on z/OS. This
  incompatibility no longer exists, so the flag is re-enabled in
  this APAR. The flag may influence performance of the process
  search engine.
  

Problem conclusion

• The use-concatenation-optimization-for-authorization-lobes flag
  is re-enabled on DB2 z/OS in this iFix.
  
  FIX AVAILABILITY:
  iFix for 8.0.1.1 is available on Fix Central, search for APAR
  JR46587 at http://www.ibm.com/support/fixcentral/
  Fix is also included in 8.0.1.2
  
  When obtaining any of the above fixes, be sure to download the
  accompanying readme, for itself and any prerequisite fixes, and
  review them thorougly.
  

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

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R801 PSY

     UP