IBM Support

PI46677: ABEND 04E-00D31010 DSNLIGLM.DSNLCCNR 0010 FOR DDF THREAD CALLING REMOTE ACCELERATED STORED PROCEDURE THAT RETURNS A RESULT SET

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2IDAA defect pi46677 dpi46677
    A DDF thread from a remote requester calling a remote stored
    procedure that returns a result set that is large enough
    to span more than one query block and has been offloaded to IDAA
    server (accelerated) may abend with
    
    ABND=04E-00D31010,U=UYSAABW
    LOC=DSNLIGLM.DSNLCCNR 0010
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAA IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
     ABEND04E AB04E S004E 04E
      04E-00D31010 00D31010 RC00D31010
       DSNLIGLM DSNLCCNR DSNLCCNR:0010 0010 VRADC0010 ABNDID0010
    

Local fix

  • no local workaround or fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA).                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptom may appear when   *
    *                      closing a remote stored procedure       *
    *                      result set which was off-loaded to      *
    *                      IDAA.                                   *
    *                      . Abend 04E-00D31010 at                 *
    *                        DSNLIGLM.DSNLCCNR:0010                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A remote application connects to a DB2 for z/OS server and
    calls a stored procedure.  The stored procedure opens a cursor
    for a result set which is off-loaded to IDAA.  After the stored
    procedure completes, the result set is returned to the calling
    application.  The calling application closes the cursor before
    fetching all the rows in the result set.  When DB2 receives the
    close cursor, it selected the wrong IDAA connection to forward
    the close request, resulting in the reported abend.
    

Problem conclusion

  • DB2 has been changed to forward close requests for off-loaded
    remote stored procedure result sets to the correct IDAA
    connection.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI46677

  • 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

    2015-08-11

  • Closed date

    2015-09-04

  • Last modified date

    2015-10-02

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

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

    UI30883 UI30884

Modules/Macros

  •    DSNLXHOC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI30883

       UP15/09/19 P F509

  • RB10 PSY UI30884

       UP15/09/19 P F509

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 #: PI46677

Modified date: 02 October 2015


Translate this page: