PH66175: SQLCODE -214 MGIHT BE RETURNED WHEN A QUERY WITH LISTAGG IS ROUTED TO DB2 ANALYTICS ACCELERATOR V7

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a query having LISTAGG function with DISTINCT is routed to
  Db2 Analytics Accelerator, SQLCODE -214 might be returned.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users who use            *
  *                 IBM Db2 Analytics Accelerator V7.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -214 might be returned when a   *
  *                      query with LISTAGG is routed to IBM     *
  *                      Db2 Analytics Accelerator V7.           *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  When a query with LISTAGG function is offloaded to IBM Db2
  Analytics Accelerator V7 and in this LISTAGG function:
    (1) DISTINCT is specified
    (2) sort-key of the ORDER BY clause is different from
        the DISTINCT string-expression
  SQLCODE -214 might be returned. To avoid this execution error,
  Db2 will detect the above situation and return SQLCODE -4742
  with reason code 11.
  
  Additional Keywords:
      IDAAV7R1/K IDAAV7R5/K
      SQLSETFUNCTION SQLFUNCTION SQLBIF
      SQLCODE214 SQLCODE4742
  

Problem conclusion

• When offloaded the query with LISTAGG function to IBM Db2
  Analytics Accelerator V7, a possible execution error with
  SQLCODE -214 will be avoided. Instead, bind/prepare error
  SQLCODE -4742 with reason code 11 will be returned.
  

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:

  UO03682

Modules/Macros

• DSNXOEX1 DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO03682

     UP25/06/25 P F506

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.