PM08740: ALC OF A COLUMN FROM DECIMAL(5,3) TO DECIMAL(10,2) / DROP-SC ACT ION RESULTS IN DATA BEING LOADED INCORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC function did not load
  the data back into a table in the correct format when a
  column was changed from DECIMAL precision and scale and an
  Action of DROP-SC is shown on panel ADB27C 'ALTER Table' or
  an Action of ALTER is shown on panel ADB27C 'ALTER Table' and
  a DROP TABLE is included in the JCL built.
  For example:
  Column changed from DECIMAL(5,3) to DEC(10,2)
  Initial value 0.150 after LOAD shows
  Column changed from DECIMAL(7,4)to DEC(10,2)
  Initial value 0.1500 after LOAD shows 15.00
  

Local fix

• No not use ALC to change DECIMAL columns when the Action shows
  DROP-SC.
  Both the Action DROP and Action ALTER without a DROP TABLE in
  the JCL correctly implement the changes without damaging the
  data.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS attempting to alter a table         *
  *                 by changing the scale of a                   *
  *                 DECIMAL column.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect values are loaded when        *
  *                      the scale of a DECIMAL column           *
  *                      is changed and the precision is         *
  *                      increased.                              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  If the precision of a DECIMAL column is increased
  and the scale is changed 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 an ALTER for DB2 versions 8 and above
  (or DROP for version 7) rather than a DROP-SC
  ("skip-convert"), DECIMAL column values are
  modified to correspond to their new, changed
  scale definition.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK58316

Modules/Macros

•    ADB27CA  ADB27CAA ADB27C0  ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK58316

     UP10/06/30 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.