PH00224: DB2 12 FOR Z/OS NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 12 for z/OS new function
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of IBM Db2                         *
  * Analytics Accelerator and the Db2                            *
  * PERCENTILE_DISC aggregate built-in                           *
  * function                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An accelerated query containing the                          *
  * Db2 12 PERCENTILE_DISC aggregate                             *
  * built-in function may result in a                            *
  * SQLCODE4742 with Reason Code(RC)=11                          *
  * from Db2 for z/OS when the target                            *
  * server is the IBM Db2 Analytics                              *
  * Accelerator. SQLCODE -4742 with                              *
  * RC=11 is valid for this scenario and                         *
  * indicates that the query contains                            *
  * an unsupported expression (in this                           *
  * case, PERCENTILE_DISC built-in                               *
  * function) for accelerating a query                           *
  * to that target Accelerator server.                           *
  *                                                              *
  * However, with this Db2 12 for z/OS                           *
  * new function APAR, Db2 will now issue                        *
  * SQLCODE -4742 with new reason code=35                        *
  * for usage of the PERCENTILE_DISC.                            *
  * New RC=35 is specific to the usage of                        *
  * Db2 12 features that are used in the                         *
  * accelerated query but unsupported by                         *
  * the target accelerator.                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  If a query containing the Db2 PERCENTILE_DISC aggregate
  built-in function is accelerated, Db2 12 for z/OS will
  now issue new RC=35 for this case of SQLCODE -4742,
  instead of the existing RC=11. New reason code 35 is
  more informative in this case than the existing  general
  RC=11, because RC=35 is specific to usage of Db2 12
  features that are unsupported by the target accelerator.
   
  The Db2 12 for z/OS SQL reference will be modified with
  new reason code 35 for the SQLCODE -4742:
   
    Reason
    35 - The query uses functionality that is available only in
    Db2 12, and the functionality is not supported by the
    accelerator server.
  
    Programmer response
    35 - Ensure that the query does not use any functionality
    that is not supported by the accelerator server.
   
  Additional search keywords:  IDAAV6R1/K IDAAV7R1/K SQLCODE4742
                               RC35 RC11
  

Problem conclusion

Temporary fix

Comments

• Apply corrective PTF when available
  

APAR Information

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

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

  UI60187

Modules/Macros

• DSNXOSP1 DSNXOBAS DSNXOBAQ DSNHSMF2 DSNXOEXF DSNXONZS DSNXOACM
  DSNXOBF6 DSNXOBF4 DSNXOBF3 DSNXODML DSNXOEX1 DSNXOBAC DSNXONZO
  DSNXONZC DSNHSMF3 DSNXOFN2 DSNXOOS1 DSNFUDIR DSNXOBFP DSNXEDP
  DSNXODTX DSNXOQ1  DSNXOQ2  DSNXORFN DSNXOOS2 DSNXIEPL DSNXFNLV
  DSNXOBFA DSNFUDRD DSNXOBFF DSNXOSCF DSNXODTR DSNXOBFC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI60187

     UP18/12/19 P F812

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.