IBM Support

PI17573: ABEND04E RC00D31010 DSNLCCNR / SUBFUNCTION: ACCS DSNX8EKGHEARTBEAT WHILE STOP ACCEL / STOP LOOPS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • STOP ACCEL cmd leads to abend04E rc00d31010 DSNLCCNR
    in SUBFUNCTION: ACCS DSNX8EKGHEARTBEAT / correlation:
    033.ACCEKG02
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAAV3R1/K IDAAV4R1/K
     STOP ACCEL hang hung loop
     ABEND04E AB04E S004E 04E
      04E-00D31010 00D31010 RC00D31010
       DSNLCCNR DSNLCCNR+1378 1378 OFFSET1378
                DSNLCCNR+1326 1326 OFFSET1326
                DSNLCCNR+1564 1564 OFFSET1564
                DSNLCCNR+150A 150A OFFSET150A
      04E-00E501A1 00E501A1 RC00E501A1
       DSNVSRX  DSNVSRX +29BC 29BC OFFSET29BC
     ABEND0C4 AB0C4 S00C4 0C4
      0C4-00000038 00000038 RC00000038
       DSNX8EKG DSNX8EKG+26D2 26D2 OFFSET26D2
       DSNX8EKG DSNX8EKG+26B4 26B4 OFFSET26B4
       DSNX8EKG DSNX8EKG+2644 2644 OFFSET2644
       DSNX8EKG DSNX8EKG+26B8 26B8 OFFSET26B8
      0C4-00000011 00000011 RC00000011
       DSNVSRX  DSNVSRX +0512 0512 OFFSET0512
    

Local fix

  • recycle DB2
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 and DB2 11 for z/OS users who     *
    *                 use IBM DB2 Analytics Accelerator (IDAA).    *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following problems are reported:    *
    *                                                              *
    *                      1.  -STOP/-START ACCEL command hang.    *
    *                                                              *
    *                      2.  DB2 abend with ABEND=04E-00D31010,  *
    *                          LOC=DSNLIGLM.DSNLCCNR+1378, +1326,  *
    *                          +1564, +150A, etc.                  *
    *                          This abend may lead to symptom 1.   *
    *                                                              *
    *                      3.  DB2 abend with ABEND=0C4-00000038,  *
    *                          LOC=DSNX8LLM.DSNX8EKG+26D2, +26B4,  *
    *                          +2644, +26B8, etc.                  *
    *                          This abend may lead to symptom 1.   *
    *                                                              *
    *                      4.  After TCP/IP or communication       *
    *                          failure, Accelerator Services will  *
    *                          be terminated without user issuing  *
    *                          the -STOP ACCEL command.            *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Accelerator services must handle many errors and abend
    conditions.  It must allow the service to complete as a result
    of normal and abnormal termination events.  In addition,
    Accelerator services should allow an automatic reconnect to the
    IDAA server after a communication failure.
    The following problems are reported:
    1.  -STOP/-START ACCEL command hang.  Any abends in DSNX8EKG
        may put the DSNX8EKG process in an inconsistent state which
        prevents the shutdown of Accelerator and DDF services.  The
        Accelerator Status will remain in STOPPEND forever until
        DB2 is recycled.  A -STOP ACCEL MODE (FORCE) has no effect.
    2.  Due to a TCPIP or communication failure, DB2 may abend with
        ABEND=04E-00D31010, LOC=DSNLIGLM.DSNLCCNR+1378, +1326,
        +1564, +150A, etc.  This abend may lead to symptom 1.
    3.  Due to a DSNX8EKG logic error, ABEND=0C4-00000038, LOC=
        DSNX8LLM.DSNX8EKG+26B4, +2644, +26D2, +26B8, etc may occur.
        This abend may lead to symptom 1.
    4.  After a communication failure, Accelerator services will be
        terminated without the user issuing a -STOP ACCEL command.
    

Problem conclusion

  • Accelerator services have been enhanced to provide more
    meaningful messages and better stability.  It now allows
    the heartbeat connection to be re-established after a
    communication failure.  Accelerator services is also enhanced
    to tolerate abend conditions.  Any fatal error will cause the
    Accelerator services to stop and a -STOP ACCEL MODE(FORCE)
    command will stop the Accelerator service immediately.
    
    DSNX870I and DSNX871I message reporting have been enhanced.
    IDAA for z/OS considers an Accelerator to be Online when
    communication with the Accelerator is successful and the
    Accelerator has reported its status to be ONLINE.  When
    Accelerator is not reachable or Accelerator has reported its
    condition has changed, IDAA for z/OS considers the Accelerator
    to be NOT ONLINE and no queries will be offloaded.
    
    Message DSNX871I will be issued when Accelerator comes Online.
    DSNX871I
      csect-name ACCELERATOR accelerator-name IS ONLINE
    
    Message DSNX870I will be issued when Accelerator comes Offline.
    DSNX870I
      csect-name ACCELERATOR accelerator-name IS NOT ONLINE
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI17573

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-09

  • Closed date

    2014-07-21

  • Last modified date

    2014-09-03

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

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

    UI19800 UI19801

Modules/Macros

  •    DSNX8API DSNX8EKG DSNX8STA DSNX8WAC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI19800

       UP14/08/05 P F408

  • RB10 PSY UI19801

       UP14/08/05 P F408

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

Modified date: 03 September 2014


Translate this page: