IBM Support

PI05851: ABEND0C4 IN DSNLCCNR RUNNING A STORED PROCEDURE WITH A QUERY THAT IS OFFLOADED TO AN IDAA SERVER

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DSNLCCNR can get an ABEND0C4 if a Stored Procedure runs an SQL
    query that is acclerated to an IDAA server.
    **************************************************************
    Additional Symptoms and Keywords:
     IDAAV3R1/K IDAAV4R1/K
     ABEND0C4 AB0C4 S00C4 0C4
      0C4-00000038 00000038 RC00000038
       DSNLCCNR DSNLCCNR+0702 0702 OFFSET0703
    

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 0C4-00000038                    *
    *                        LOC=DSNLIGLM.DSNLCCNR+0702            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A local or remote application calls a stored procedure running
    on a DB2 for z/OS system to offload 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 0C4-00000038 DSNLIGLM.DSNLCCNR+0702.
    

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.
    
    Additional Keywords: IDAAV3R1/K IDAAV4R1/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI05851

  • 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

    2013-11-08

  • Closed date

    2014-01-19

  • Last modified date

    2014-03-03

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

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

    UI14332 UI14333

Modules/Macros

  • DSNLXRUW
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI14332

       UP14/02/04 P F402

  • RB10 PSY UI14333

       UP14/02/04 P F402

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

Modified date: 03 March 2014


Translate this page: