IBM Support

PI62727: DSNLXROP ABEND WHEN CALLING SERVER STORED PROCEDURE FROM CLIENT, AND THE STORED PROCEDURE DOES QUER 16/05/20 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2IDAA defect pi62727 dpi62727
    DSNLXROP abend with REASON=00D31010
    when calling server stored procedure
    from client, and the stored procedure does query offload
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAA IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K IDAAV5R1/K
     ABEND04E AB04E S004E 04E
      04E-00D3440B 00D3440B RC00D3440B
       DSNLXGLM DSNLXROP DSNLXROP:007B 007B VRADC007B ABNDID007B
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA).                          *
    *                 DB2 11 for z/OS users only.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptom may occur when    *
    *                      calling a remote stored procedure that  *
    *                      offloads a query to IDAA.               *
    *                      . ABEND04E-00D3440B                     *
    *                        LOC=DSNLXGLM.DSNLXROP:007B            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An application connects to a DB2 11 for z/OS server and calls a
    stored procedure defined to return a result set.  The stored
    procedure offloads the query for the result set to IDAA.  When
    IDAA returns the offloaded query results, the buffer used to
    contain the rows is too small, resulting in ABEND04E-00D3440B
    LOC=DSNLXGLM.DSNLXROP:007B.
    Note that this abend can occur only when PI59532/UI36933 is
    installed.
    

Problem conclusion

  • DB2 has been changed to obtain a larger buffer when the original
    buffer is too small to contain the results of an offloaded
    query.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI62727

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-05-20

  • Closed date

    2016-07-21

  • Last modified date

    2016-09-02

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

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

    UI39561

Modules/Macros

  •    DSNLXROP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI39561

       UP16/08/05 P F608 «

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

Reference #: PI62727

Modified date: 02 September 2016


Translate this page: