PI29725: ABEND04E, RC00D35011 FROM DSNLZHR0:0050 FOR A REMOTE REQUESTER ACCESSING MULTIPLE IDAA SERVERS IN THE SAME UNIT OF WORK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A requester into DB2 that runs queries that offload onto
  multiple IDAA servers can abend with an ABEND04E, RC00D35011
  from DSNLZHR0:0050. The problem is intermittent.
  DSNLZHR0 00D35011
  
  Customers running IDAA with 2 boxes may also see
  ABND=04E-00D31010 DSNLIGLM.DSNLCCNR:001B
  ***************************************************************
  Additional Symptoms and Keywords:
   IDAA IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
   ABEND04E AB04E S004E 04E
    04E-00D35011 00D35011 RC00D35011
     DSNLZHR0 DSNLZHR0:0050 0050 VRADC0050 ABID0050 ABNDID0050
    04E-00D31010 00D31010 RC00D31010
     DSNLCBFM DSNLCBFM:0005 0005 VRADC0005 ABID0005 ABNDID0005
     DSNLCCNR DSNLCCNR:001B 001B VRADC001B ABID001B ABNDID001B
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
  *                 Accelerator (IDAA).                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following symptoms may occur        *
  *                      during a remote query offload:          *
  *                      . Abend 04E-00D35011 at                 *
  *                        DSNLZLLM.DSNLZHR0:0050                *
  *                      . Abend 04E-00D31010 at                 *
  *                        DSNLIGLM.DSNLCBFM:0005                *
  *                      . Abend 04E-00D31010 at                 *
  *                        DSNLIGLM.DSNLCCNR:001B                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A remote application connects to a DB2 for z/OS server that is
  configured to utilize two or more IDAA servers.  The remote
  application executes many queries which DB2 offloads across the
  multiple IDAA servers.  During fetch of the result sets, DB2
  may route the fetch to the wrong IDAA server, leading to the
  reported abends.
  

Problem conclusion

• DB2 has been changed to route fetch requests to the correct
  IDAA server.
  Additional Keywords: IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
  

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:

  UI23707 UI23708

Modules/Macros

•    DSNLXOQS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23707

     UP14/12/23 P F412

• RB10 PSY UI23708

     UP14/12/23 P F412

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.