PI73502: QUERY CONTAINING THE ROUND FUNCTION WITH CASE EXPRESSION MAY RETURN -104 WHEN EXECUTED ON ACCELERATOR 17/01/06 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Query containing the ROUND function with CASE expression returns
  SQLCODE -104 when executed on an accelerator.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 and DB2 11 for z/OS      *
  *                 using query acceleration who have            *
  *                 PI54835 (UI34965/UI34966) applied            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes a SQLCODE -104          *
  *                      problem for a query routed              *
  *                      to an accelerator and there is a        *
  *                      CASE expression in the query.           *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When there is CASE expression in a query and the query
  is routed to an accelerator, SQLCODE -104 might be
  returned due to an incorrect query conversion.
  
  Keywords:
  IDAAV5R1/K SQLCODE104  SQLCASE
  

Problem conclusion

• DB2 code is fixed to correctly convert the query with the
  CASE expression. SQLCODE -104 is no longer issued when the
  query with the CASE expression is accelerated.
  

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:

  PI75606 UI44327 UI44328

Modules/Macros

• DSNXIAIX DSNXICIX DSNXICLN DSNXIDIX DSNXISB6
  DSNXONZC DSNXONZO DSNXORFN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI44327

     UP17/02/16 P F702 Ø

• RB10 PSY UI44328

     UP17/02/15 P F702 Ø

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.