PK16586: ALC LINE COMMAND CHANGE OF A DECIMAL SCALE DOES NOT USE LOAD UTI LITY DISCARD FUNCTION AND TRUNCATES HIGH ORDER VALUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration tool ALC line command used to change the
  scale of a DECIMAL column did not use the LOAD utility discard
  function for data to large to changed column definition and
  instead truncated the data values.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of DB2 Administration Tool, who       *
  *                 attempt  to alter a decimal column  by       *
  *                 increasing its scale while leaving its       *
  *                 length unchanged, are affected.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When  altering  a  decimal   column  by *
  *                      increasing its scale while leaving  its *
  *                      length unchanged, if data in the column *
  *                      was  too large  to  fit  in the altered *
  *                      column and the "D" (discard) option was *
  *                      chosen, the data would be corrupted.    *
  *                      .*                                      *
  *                      ALC  line  command  used  to change the *
  *                      scale of a  DECIMAL  column did not use *
  *                      the  LOAD  utility discard function for *
  *                      data  too  large for the changed column *
  *                      definition  and  instead  truncated the *
  *                      data values.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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 UK17340

     UP06/08/25 P F608

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.