IBM Support

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

Subscribe

You can track all active APARs for this component.

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



Document information

More support for: IBM Business Process Manager Standard

Software version: 855

Reference #: JR52634

Modified date: 21 May 2015