PK56652: ALC CHANGE OF COLUMN FROM DECIMAL (3,0) TO (11,7) INCORRECTLY CHANGES DATA WITH INCORRECT PRECISION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User has table with column defined with decimal (3,0) and uses
  ALC to alter the column to decimal (11,7). These were the
  results:
        Define decimal(3,0)             Changed to decimal(11,7)
          12.                               .0000012
           1.                               .0000001
         199.                               .0000199
  
  .
  The packed decimal values of 3 digits in the unload data was
  loaded in the new 11 digits column with a changed precision
  from 0 to 7 in the column incorrectly.
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool attempting to        *
  *                 alter a table by increasing the scale        *
  *                 of a DECIMAL column.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect values are loaded when the    *
  *                      scale of an altered DECIMAL column is   *
  *                      increased.                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  If the scale of a DECIMAL column is increased as part of an
  alter, the DB2 Admin tool chooses "skip-convert" processing,
  which means the values in a column produced in the UNLOAD step
  are used without modification for the final LOAD step.  The
  problem arises for DECIMAL column values because those unloaded
  values by themselves carry no information about the position of
  the decimal point, that is, the scale of the value.
  

Problem conclusion

• By forcing a DROP rather than a DROP-SC ("skip-convert"),
  DECIMAL column values are modified to correspond to their new,
  increased scale, definition.
  

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

•    ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK35294

     UP08/04/16 P F804

• R720 PSY UK35295

     UP08/04/16 P F804

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.