IBM Support

PI56835: ABEND04E RC00D31104 DSNLIGLM DSNLCCNR 0001

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2SP DB2IDAA
    Abend04E rc00D31104 DSNLIGLM DSNLCCNR 0001
    **************************************************************
    Additional Symptoms and Keywords:
     ABEND04E AB04E S004E 04E
      04E-00D31104 00D31104 RC00D31104
       DSNLCCNR DSNLCCNR:0001 0001 VRADC0001 ABNDID0001
     IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K IDAAV5R1/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA).                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptom appears during    *
    *                      a query offload to IDAA:                *
    *                      . ABEND 04E-00D31104                    *
    *                        LOC=DSNLIGLM.DSNLCCNR:0001            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A local or remote application calls a stored procedure running
    on a DB2 for z/OS system which offloads a query to the IBM Data
    Analytics Accelerator (IDAA).  After the stored procedure
    completes execution, DB2 cleans up all outbound connections
    established by the stored procedure.  During this process, DB2
    referenced the wrong location name for the IDAA server, leading
    to an abend 04E-00D31104 DSNLIGLM.DSNLCCNR:0001.
    

Problem conclusion

  • DB2 for z/OS is changed to reference the correct IDAA server
    location name when cleaning up connections established by a
    stored procedure.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI56835

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-08

  • Closed date

    2016-03-17

  • Last modified date

    2016-04-05

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

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

    UI36305

Modules/Macros

  • DSNLXRUW
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI36305

       UP16/04/01 P F603

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":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 April 2016