JR52634: THE INSTALLED APPS PAGE OF THE PROCESS ADMIN CONSOLE CAUSES PERFORMANCE ISSUES WHEN YOU HAVE NUMEROUS BPD INSTANCES
A fix is available
Closed as fixed if next.
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
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);
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.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels