PI09807: -STOP ACCELERATOR COMMAND MAY HANG THE SUBSYSTEM

Obtain the fix for this APAR.

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 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.