PH20846: DDF thread abend 04E-00D31010 LOC=DSNLILLM.DSNLQINA:0015

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDF thread abend ABND=04E-00D31010 LOC=DSNLILLM.DSNLQINA:0015.
  
  A secondary abend, ABND=04E-00D3111C LOC=DSNLILLM.DSNLIRTR:000A
  may occur during thread inactivation processing as a result
  of the original abend 00D31010.
  
  Abend ABND=04E-00E2000D from LOC=DSNLZS00.DSNSVSFB+00A18
  when attempting to free ZDSC that is already freed
  (DSNLZS00 at UI64268 for offset +00A18)
  
  Abend S04E-00E2000D from DSNLZS00.DSNSVSFB may also be seen
  during remote query offload with 00D35011 from DSNLZRPA:001E
  
  
  Additional keywords and symptoms:
  ***********************************
  DB2DDF DDF ABEND04E 00D31010
  00D3111C DSNLQINA ABNDID0015
  DSNLIRTR ABNDID000A
  IDAAV5R1/K IDAAV7R1/K
  DSNLZS00 ZDSC 00E2000D
  DSNLZRPA ABNDID001E 00D35011
  RC00D3111C RC00D35011 RC00E2000D
  RC00D31010
  

Local fix

• no local workaround or fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 users of the IBM Data Analytics                      *
  * Accelerator (IDAA).                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The following abends may occur after a                       *
  * remote query offload:                                        *
  * - ABND=04E-00D31010                                          *
  *   LOC=DSNLILLM.DSNLQINA:0015                                 *
  * - ABND=04E-00D35011                                          *
  *   LOC=DSNLZGLM.DSNLZRPA:001E                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  A remote application bound with KEEPDYNAMIC(YES) connects to a
  Db2 12 for z/OS server and offloads a dynamic query. After the
  application ends, Db2 terminates its connection and pools
  the server thread for reuse. Db2, however, did not clean up
  internal control blocks related to KEEPDYNAMIC statements used
  for remote query offloads.  These residual control blocks are
  left remaining with the pooled server thread.  Subsequently,
  another connection comes into Db2, is assigned the pooled
  thread, and an abend 04E-00D31010 can occur.
  An abend 04E-00D35011 may also occur if Db2 attempts to free
  residual control blocks for an already terminated downstream
  IDAA connection.
  

Problem conclusion

• Db2 connection termination processing has been changed to clean
  up all internal control blocks related to remote query offloads
  associated to packages bound KEEPDYNAMIC(YES).
  

Temporary fix

Comments

APAR Information

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

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

  UI67960

Modules/Macros

• DSNLXSRL DSNLXREL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67960

     UP20/02/26 P F002

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.