IBM Support

PI29725: ABEND04E, RC00D35011 FROM DSNLZHR0:0050 FOR A REMOTE REQUESTER ACCESSING MULTIPLE IDAA SERVERS IN THE SAME UNIT OF WORK

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A requester into DB2 that runs queries that offload onto
    multiple IDAA servers can abend with an ABEND04E, RC00D35011
    from DSNLZHR0:0050. The problem is intermittent.
    DSNLZHR0 00D35011
    
    Customers running IDAA with 2 boxes may also see
    ABND=04E-00D31010 DSNLIGLM.DSNLCCNR:001B
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAA IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
     ABEND04E AB04E S004E 04E
      04E-00D35011 00D35011 RC00D35011
       DSNLZHR0 DSNLZHR0:0050 0050 VRADC0050 ABID0050 ABNDID0050
      04E-00D31010 00D31010 RC00D31010
       DSNLCBFM DSNLCBFM:0005 0005 VRADC0005 ABID0005 ABNDID0005
       DSNLCCNR DSNLCCNR:001B 001B VRADC001B ABID001B ABNDID001B
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA).                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptoms may occur        *
    *                      during a remote query offload:          *
    *                      . Abend 04E-00D35011 at                 *
    *                        DSNLZLLM.DSNLZHR0:0050                *
    *                      . Abend 04E-00D31010 at                 *
    *                        DSNLIGLM.DSNLCBFM:0005                *
    *                      . Abend 04E-00D31010 at                 *
    *                        DSNLIGLM.DSNLCCNR:001B                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A remote application connects to a DB2 for z/OS server that is
    configured to utilize two or more IDAA servers.  The remote
    application executes many queries which DB2 offloads across the
    multiple IDAA servers.  During fetch of the result sets, DB2
    may route the fetch to the wrong IDAA server, leading to the
    reported abends.
    

Problem conclusion

  • DB2 has been changed to route fetch requests to the correct
    IDAA server.
    Additional Keywords: IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI29725

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-14

  • Closed date

    2014-12-08

  • Last modified date

    2015-01-02

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

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

    UI23707 UI23708

Modules/Macros

  •    DSNLXOQS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI23707

       UP14/12/23 P F412

  • RB10 PSY UI23708

       UP14/12/23 P F412

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: A10

Reference #: PI29725

Modified date: 02 January 2015


Translate this page: