IBM Support

JR51656: DBUPGRADE COMMAND MIGHT HANG WHEN YOU ENABLE LOGGING FOR LOB COLUMNS ON DB2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DBUpgrade will hang when alter table LSW_BPD_INSTANCE_DATA on
    DB2 in some cases
    

Local fix

  • No local fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  IBM BPM Advanced                            *
    *                  IBM BPM Standard                            *
    *                  IBM BPM Express                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: Running the DBUpgrade command might     *
    *                      hang at either of the following SQL     *
    *                      statements when you migrate IBM         *
    *                      Business Process Manager (BPM) to IBM   *
    *                      BPM Version 8.5.5.0 on the IBM DB2      *
    *                      database.                               *
    *                      ALTER TABLE LSW_BPD_INSTANCE_DATA       *
    *                      ACTIVATE NOT LOGGED INITIALLY           *
    *                      or                                      *
    *                      ALTER TABLE                             *
    *                      LSW_TASK_EXECUTION_CONTEXT ACTIVATE     *
    *                      NOT LOGGED INITIALLY                    *
    *                      This issue occurs because the           *
    *                      previous upgrade step on these two      *
    *                      tables encountered an unreleased lock.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The issue happens only when the user uses DB2 and there is no
    update needed for data in the IBM Process Server database
    including process instances or tasks data
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.5.0 that prevents the
    system from hanging by committing the SQL transaction explicitly
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR51656:
    
    1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue
    2. Select APAR or SPR, enter JR51656, and click Continue.
    
    When you download fix packages, also download the readme file
    for each fix. Review each readme file for additional
    installation instructions and information about the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR51656

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-31

  • Closed date

    2014-12-11

  • Last modified date

    2014-12-11

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
11 December 2014