PM12576: MESSAGE INZU238E AND INZU366I RC08 FOR SELECT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INZU238E UNEXPECTED UNSUPPORTED SELECT
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x106a00d)
  Error message INZU238E UNEXPECTED UNSUPPORTED SELECT is issued
  for a SELECT statement that contains the DIGITS scalar function
  applied on a constant, and included in either:
  - a CASE expression
  - an IFNULL scalar function
  - a COLAESCE scalar function
  For example:  SELECT  COALESCE( DIGITS(COLDEC50) , DIGITS(0) )
  PB10645
  

Local fix

• Adding in the VUU030/ULOPTNS parmlib variable the non-documented
  value FIX(OPTCST) which will de-activate an optimization made on
  constants.  BUT this de-activation can have a very negative
  impact if using IN predicate with a large number of constant
  values. The creation of hash code is deactivated and the
  performance impact can be huge in such cases.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message INZU238E UNEXPECTED       *
  *                      UNSUPPORTED SELECT is issued for a      *
  *                      SELECT statement that contains the      *
  *                      DIGITS scalar function applied on a     *
  *                      constant, and included in either:       *
  *                      - a CASE expression                     *
  *                      - an IFNULL scalar function             *
  *                      - a COLAESCE scalar function            *
  *                      Example                                 *
  *                      SELECT  COALESCE( DIGITS(COLDEC50) ,    *
  *                      DIGITS(0) ) FROM table_name             *
  *                      PM 10645                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inznode  module was changed to handle expression with
  DIGIT(constant) correctly.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK58095

     UP10/06/24 P F006

• R320 PSY UK58096

     UP10/06/24 P F006

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.