IBM Support

PM45187: ABEND04E RC00C90101 DSNIQISE 5001 IN NOTIFY EXIT 11/09/14 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Dump Title: RDIC ABND 04E 00C90101 U=SYSOPR M=(N) C=910.DMC
    -DSNIQISE,M=DSNTFRCV,LOC=DSNIDM DSNIQISE 5001
    Notify exit issued ABEND04E RC00C90101 DSNIQISE ERQUAL5001 when
    multiple notify exits executed DSNIQISE concurrently.
    Additional Symptoms:
    DSNIFSQD ERQUAL5006 5006
    .
    KEYWORDS: DB2MIGV10/K  DB2MIGV9/K  DB2COEXIST/K
    .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 sequence objects (identity      *
    *                 column, stand-alone sequence, internal       *
    *                 sequence objects for xml) in a Data          *
    *                 Sharing coexistence environment, with        *
    *                 both DB2 V10 and DB2 pre-V10 members,        *
    *                 with activities requiring interaction        *
    *                 between a DB2 V10 member and a               *
    *                 DB2 pre-V10 member via DB2 notification.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIQISE 5001       *
    *                      IN NOTIFY EXIT.                         *
    *                                                              *
    *                      Unexpected gaps in cache values of      *
    *                      sequence objects due to mass-           *
    *                      invalidation of all sequence-related    *
    *                      in-memory structures.                   *
    *                                                              *
    *                      This problem, caused by incorrect       *
    *                      interpretation of the NOTIFY message,   *
    *                      can happen ONLY in a data sharing       *
    *                      coexistence environment where the       *
    *                      NOTIFY message is sent by a DB2 V10     *
    *                      member and received by a DB2 pre-V10    *
    *                      member or vice versa.                   *
    *                                                              *
    *                      The NOTIFY message in this context may  *
    *                      be sent from one DB2 member to the      *
    *                      other members of the data sharing       *
    *                      group, when:                            *
    *                      - a sequence object is ALTERed,         *
    *                      - CREATE/ALTER of a sequence object     *
    *                        is rolled back,                       *
    *                      - a sequence object is dropped.         *
    *                                                              *
    *                      The problem exists ONLY in a            *
    *                      COEXISTENCE environment as stated       *
    *                      above.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The problem happened due to an incompatible message structure
    between DB2 V10 and DB2 pre-V10 members.
    

Problem conclusion

  • Code has been added to DB2 zos v8, v9, and v10 to interpret the
    NOTIFY message using a message structure of the sender.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM45187

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-05

  • Closed date

    2011-10-21

  • Last modified date

    2013-02-20

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

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

    UK73140 UK73141 UK73142

Modules/Macros

  •    DSNIQISE DSNTLPLK
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK73140

       UP11/11/08 P F111 ®

  • R810 PSY UK73141

       UP11/11/08 P F111 ®

  • R910 PSY UK73142

       UP11/11/08 P F111 ®

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.



Document information

More support for: DB2 for z/OS

Software version: 910

Reference #: PM45187

Modified date: 20 February 2013


Translate this page: