IBM Support

PM77208: NUMEROUS ABEND SYMPTOMS INCLUDING A DB2 CRASH MAY OCCUR WHEN EXECUTING A SQL STATEMENT WITH CPU PARALLELISM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • NUMEROUS ABEND SYMPTOMS INCLUDING A DB2 CRASH MAY OCCUR DUE TO A
    LARGE STORAGE OVERLAY WHEN EXECUTING A SQL STATEMENT WITH CPU
    PARALLELISM
    PLEASE NOTE THAT THIS LARGE STORAGE OVERLAY COULD CAUSE NUMEROUS
    UNPREDICTABLE SYMPTOMS INCLUDING A DB2 CRASH.
    HERE ARE SOME POSSIBLE SYMPTOMS:
    ABEND04E RC00E2000D AT DSNXPDST DSNSVSFB OFFSET0848
    ABEND0C4 RC00000038 AT DSNXRFN OFFSET2344
    ABEND0C4 RC00000038 AT DSNXECPT OFFSET0146
    ABEND04E RC00F30801 AT DSNAPRHX OFFSET20D4
    OTHER FAILING SYMPTOMS ARE POSSIBLE
    

Local fix

  • TURN OFF PARALLELISM FOR ANY IMPACTED APPLICATION WITH CURRENT
    DEGREE OF 1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
    *                 users with parallelism enabled.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: Numerous ABEND symptoms including       *
    *                      a DB2 crash may occur.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Numerous ABENDs and a DB2 crash may occur.
    When we run a query with large record size, DB2 parallelism
    may not be able to handle it correctly. Since some internal
    inconsistency has been observed about how to handle large size
    records. The problem is not query specific, only happens when
    combined record size passing by parallel pipe is larger than
    32K.
    

Problem conclusion

  • DB2 has been fixed to handle large size record case correctly
    under parallelism processing. After the fix, ABENDs no longer
    occur.
    
    Additional keywords: PARALLELISM  SQLPARALLELISM
                         DB2PARALL/K
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM77208

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-15

  • Closed date

    2013-03-26

  • Last modified date

    2013-05-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK92916 UK92917

Modules/Macros

  • DSNXOCON DSNXOPTT DSNXPCRT DSNXPRE2 DSNXPSEN
    DSNXPSPD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK92916

       UP13/04/18 P F304

  • R910 PSY UK92917

       UP13/04/18 P F304

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 May 2013