A fix is available
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 number
JR52634
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
855
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-02-25
Closed date
2015-03-04
Last modified date
2015-05-21
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 October 2021