JR52634: THE INSTALLED APPS PAGE OF THE PROCESS ADMIN CONSOLE CAUSES PERFORMANCE ISSUES WHEN YOU HAVE NUMEROUS BPD INSTANCES

Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

APAR status

• Closed as fixed if next.

Error description

• When you have numerous business process definition (BPD)
  instances in the IBM BPM LSW_BPD_INSTANCE table, the Installed
  App page of the Process Admin Console might have performance
  issues and cause heavy database processing.
  You will see the find-installed-snapshots-query running at
  regular intervals. You might see it take several seconds or even
  minutes if the BPM LSW_BPD_INSTANCE table row count grows large
  enough.
  You will see table scans occurring on table BPM LSW_BPD_INSTANCE
  because of this part of the query:
  SELECT  COUNT(*)
     FROM    lsw_bpd_instance i, lsw_bpd bpd
     WHERE   i.execution_status  IN (1,3,6)
         AND i.snapshot_id =snaps.snapshot_id
         AND i.cached_bpd_version_id=bpd.version_id
         AND i.tip   |= 'T'
          )    AS snapshotInstancesRunning,
  The query can also be used in other parts of the product
  although the Process Admin console is the most common place.
  most common place to use it.
  When looking at hung threads and javacores this method call
  will be present
  com.lombardisoftware.server.ejb.runtime.RuntimeServicesCore.getI
  nstalledSnapshots
  

Local fix

• An index should be added to the database to avoid table scans
  when processing the query.
  You should add the index to the LSW_BPD_INSTANCE table with the
  4 columns from the query: execution_status, snapshot_id,
  cached_bpd_version_id, and tip.
  Example creation index script:
  create index BPM_JR52634 on LSW_BPD_INSTANCE
  (execution_status, snapshot_id,cached_bpd_version_id, tip);
  

Problem summary

• The performance of a subquery to determine the count of
  instances decreases with a growing number of instances.
  
  An index on the involved columns of the subquery avoids the
  performance degradation.
  
  A fix that creates the index needed to avoid table scans on the
  instance tables will be incorporated into a later release.
  

Problem conclusion

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

• R855 PSN

     UP