PH67428: UNDUE INZU250E AND SUBSEQUENT FAILURE OR UNDESIRED PROCESSING IN SQL MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The INZU250E INVALID DATETIME CONSTANT 'datetime value' message
  is unduly issued regarding a valid date/time constant specified
  by a logical unload.
  - If the native mode is requested (DB2 NO), the unload stops and
  ends with a completion code of 8.
  - If the SQL mode is allowed (DB2 YES), the processing continues
  in SQL mode with a completion code greater than or equal to 4.
  
  This occurs if all the following conditions are fulfilled:
  - the Db2 sub-system is set up with a LOCAL DATE/TIME format
  - the logical unload specifies an SQL expression involving a
  date/time constant, (the expression may consist of the date/time
  constant itself) either in the list of selected items or in the
  WHERE clause
  

Local fix

• - For an unload from an image copy (COPYDDN option), no
  workaround exists.
  
  - For any other unload, specify DB2 FORCE to allow the unload to
  complete without the INZU250E message being unduly issued.
  
  - For any unload running with DB2 YES that completes
  successfully, a return code of 4 will be issued regardless of
  whether the INZU250E message is issued or not, and needs to be
  tolerated.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The INZU250E INVALID DATETIME CONSTANT  *
  *                      'datetime value' message is unduly      *
  *                      issued regarding a valid date/time      *
  *                      constant specified by a logical unload. *
  *                                                              *
  *                        - If the native mode is requested     *
  *                          (DB2 NO), the unload stops and      *
  *                          ends with a completion code of 8.   *
  *                                                              *
  *                        - If the SQL mode is allowed (DB2     *
  *                          YES), the processing continues in   *
  *                          SQL mode with a completion code     *
  *                          greater than or equal to 4.         *
  *                                                              *
  *                      This occurs if all the following        *
  *                      conditions are fulfilled:               *
  *                                                              *
  *                         - the Db2 sub-system is set up with  *
  *                           a LOCAL DATE/TIME format           *
  *                                                              *
  *                         - the logical unload specifies an    *
  *                           SQL expression involving a         *
  *                           date/time constant, (the           *
  *                           expression may consist of the      *
  *                           date/time constant itself) either  *
  *                           in the list of selected items or   *
  *                           in the WHERE clause                *
  *                                                              *
  *                                                              *
  *                      Local fix:                              *
  *                                                              *
  *                        -  For an unload from an image copy   *
  *                           (COPYDDN option), no workaround    *
  *                           exists.                            *
  *                        -  For any other unload, specify DB2  *
  *                           FORCE to allow the unload to       *
  *                           complete without the INZU250E      *
  *                           message being unduly issued.       *
  *                         - For any unload running with DB2    *
  *                           YES that completes successfully,   *
  *                           a return code of 4 will be issued  *
  *                           regardless of whether the          *
  *                           INZU250E message is issued or      *
  *                           not, and needs to be tolerated.    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  undue INZU250E and subsequent failure or undesired processing
  in SQL mode
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• R520 PSY UO04514

     UP25/08/23 P F508

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.