PH24457: INCORRECT UNLOADED DATA IN NATIVE MODE WITH SQL EXPRESSIOIN REQUIRING CONVERSION FROM NEGATIVE SMALLINT/INTEGER TO BIGINT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The data unloaded for a logical unload run in
  native mode contain fields with an incorrect value and/or do not
  match the specified WHERE clause, if any.
  
  This occurs if the evaluation of an SQL expression involved in
  the SELECT statement (either in the FROM or in the WHERE clause)
  requires the conversion of a negative SMALLINT or INTEGER value
  into a BIGINT value.
  

Local fix

• consider running the unload in SQL mode by specifying the DB2
  FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The data unloaded for a logical unload  *
  *                      run in native mode contain fields with  *
  *                      an incorrect value and/or do not match  *
  *                      the specified WHERE clause, if any.     *
  *                                                              *
  *                      This occurs if the evaluation of an SQL *
  *                      expression involved in the SELECT       *
  *                      statement (either in the FROM or in the *
  *                      WHERE clause) requires the conversion   *
  *                      of a negative SMALLINT or INTEGER value *
  *                      into a BIGINT value.                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Incorrect unloaded data for unload in  native mode with SQL
  expression requiring conversion from negative SMALLINT/INTEGER
  to BIGINT
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

• ×**** PE20/10/28 FIX IN ERROR. SEE APAR PH31023  FOR DESCRIPTION
  ×**** PE20/10/28 FIX IN ERROR. SEE APAR PH31023  FOR DESCRIPTION
  

APAR Information

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

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

  UI69508

Modules/Macros

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69508

     UP20/05/22 P F005

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.