PH59313: DECIMAL DATA UNLOADED WITH INCORRECT PRECISION IF COMING FROM ALTERATION FROM SMALLINT OR BIGINT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload processed in native mode produces output fields
  with an incorrect scale (incorrout) for a decimal column with a
  positive scale. The integer  part is written as the fractional
  part.For example, if a SMALLINT column with a value of 10 has
  been converted into a DECIMAL(5,2) column, the unloaded value
  represents 0.10 instead of 10.00.
  This occurs if all the following conditions are met:
  - the affected column DECIMAL column results from an alteration
  from a SMALLINT or BIGINT column
  - there are still records in the former formats, IE. where the
  altered column still has the original representation of the
  numerical value (as a SMALLINT or BIGINT data)
  

Local fix

• run the unload in SQL mode by specifying the DB2 FORCE option or
  REORG the involved tablespace.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload processed in native    *
  *                      mode produces output fields with an     *
  *                      incorrect scale (incorrout) for a       *
  *                      decimal column with a positive scale.   *
  *                      The integer  part is written as the     *
  *                      fractional part.For example, if a       *
  *                      SMALLINT column with a value of 10 has  *
  *                      been converted into a DECIMAL(5,2)      *
  *                      column, the unloaded value represents   *
  *                      0.10 instead of 10.00.                  *
  *                                                              *
  *                      This occurs if all the following        *
  *                      conditions are fulfilled:               *
  *                      - the affected column DECIMALcolumn     *
  *                      results from an alteration from a       *
  *                      SMALLINT or BIGINT column               *
  *                      - there are still records in the        *
  *                      former formats, I.e. where the altered  *
  *                      column still has the original           *
  *                      representation of the numerical value   *
  *                      (as a SMALLINT or BIGINT data)          *
  *                                                              *
  *                      Local fix: run the unload in SQL mode   *
  *                      by specifying the DB2 FORCE option or   *
  *                      REORG the involved tablespace."         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  decimal data unloaded with incorrect precision  if coming from
  alteration from SMALLINT or BIGINT
  

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:

  UI95923

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI95923

     UP24/04/01 P F403

• R520 PSY UI95922

     UP24/04/01 P F403

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.