IBM Support

PI09807: -STOP ACCELERATOR COMMAND MAY HANG THE SUBSYSTEM

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DCR DM1793
    See APAR PM92514 for DB2 10 for z/OS equivalent.
    -STOP ACCELERATOR command may hang the subsystem
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAAV2R1/K   - for IDAA V2
     IDAAV3R1/K   - for IDAA V3
     IDAAV4R1/K   - for IDAA V4
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users who use IBM DB2    *
    *                 Analytics Accelerator (IDAA).                *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following is the list of reported   *
    *                      problem symptoms:                       *
    *                                                              *
    *                      1. -STOP ACCEL command may not complete *
    *                         and prevent any subsequent DB2       *
    *                         command from being processed.        *
    *                                                              *
    *                      2. -STOP ACCEL MODE(FORCE) may cause    *
    *                         DB2 subsystem termination.           *
    *                                                              *
    *                      3. ABND0E4 RC00E70005 in CSECT          *
    *                         DSNX8STA.                            *
    *                                                              *
    *                      4. ABND0D6 RC00000026 in CSECT          *
    *                         DSNX8EKG.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1. The -STOP ACCEL command uses a single command task for
       processing. If the command is waiting for long running
       queries to complete, no other ACCEL commands can be executed.
       In addition, if the command is issued from the console, no
       other commands from that console will be honored until the
       command completes.
    
    2. -STOP ACCEL MODE(FORCE) does not obtain the correct
       serialization to terminate in process accelerated queries.
       This may result in improper processing and subsystem
       termination.
    
    3. During -START ACCEL command processing, an ABEND04E
       RC00E70005 may be encountered in CSECT DSNX8STA if the
       accelerator entry has been deleted from the catalog.
    
    4. After the start of an accelerator (either by command or
       via startup automation), an ABEND0D6 may occur in CSECT
       DSNX8EKG if Distributed Data Facility (DDF) services are not
       available.
    

Problem conclusion

  • DB2 -STOP ACCEL and -START ACCEL command processing has been
    corrected to handle the reported issues.
    
    NOTE:  There are 1 changed message and 4 new messages added
           to better describe the state of a given accelerator.
    
    The changed message is as follows:
    DSNX862I
    csect-name ACCELERATOR accelerator-name ALREADY STOPPED OR IS
    IN THE PROCESS OF STOPPING
    
    Explanation
    The accelerator server is already stopped or is stopping.
    
    csect-name
    The name of the control section that issued the message.
    
    accelerator-name
    The name of the accelerator server.
    
    System action
    Processing continues.
    
    User response
    No action is required.
    
    Severity
    0
    
    The new messages are as follows:
    
    DSNX863I
    csect-name STOP ACCELERATOR INITIATED FOR accelerator-name
    
    Explanation
    The accelerator server is stopping.
    
    csect-name
    The name of the control section that issued the message.
    
    accelerator-name
    The name of the accelerator server.
    
    System action
    No new work can be directed to this accelerator until it is
    restarted.
    
    User response
    No action is required.
    
    Severity
    0
    
    DSNX870I
    csect-name ACCELERATOR accelerator-name IS NOT ONLINE
    
    Explanation
    The accelerator heartbeat has detected the accelerator is no
    longer online.
    
    csect-name
    The name of the control section that issued the message.
    
    accelerator-name
    The name of the accelerator server.
    
    System action
    No new work can be directed to this accelerator until it is
    back online.
    
    User response
    No action is required.
    
    Severity
    0
    
    DSNX871I
    csect-name ACCELERATOR accelerator-name IS ONLINE
    
    Explanation
    The accelerator heartbeat has detected the accelerator is
    online.
    
    csect-name
    The name of the control section that issued the message.
    
    accelerator-name
    The name of the accelerator server.
    
    System action
    None.
    
    User response
    No action is required.
    
    Severity
    0
    
    
    DSNX872I
    csect-name ACCELERATOR accelerator-name IN THE PROCESS OF
    STOPPING
    
    Explanation
    The accelerator server was stopping when -START ACCEL command
    was issued.
    
    csect-name
    The name of the control section that issued the message.
    
    accelerator-name
    The name of the accelerator server.
    
    System action
    The -START ACCEL command is not executed.
    
    User response
    Reissue -START ACCEL command to start the accelerator server
    once it is stopped.
    
    Severity
    0
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI09807

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-16

  • Closed date

    2014-04-11

  • Last modified date

    2014-05-02

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

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

    UI16997

Modules/Macros

  • DSNFCDIR DSNFXDIR DSNLDALB DSNLSSST DSNLTGBK DSNLTSET DSNLXPCA
    DSNTABA  DSNTADL  DSNTRSTE DSNXONZA DSNXONZB DSNX8API DSNX8CDA
    DSNX8EKG DSNX8EPL DSNX8ESW DSNX8IN2 DSNX8STA DSNX8STO DSNX8TER
    DSNX8WAC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI16997

       UP14/04/29 P F404 ½

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

Modified date: 02 May 2014


Translate this page: