PI11395: CKZ54772W TABLE COLUMN MISMATCH, ATTRIBUTE SCALE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Warning message "CKZ54772W TABLE COLUMN Mismatch, Attribute
  SCALE" may be issued after migrating to DB2 version 10
  new-function mode and above.
  .
  This will address an issue where pre DB2 Version 10 new-function
  mode, TIMESTAMP columns have a length of 10 bytes and a scale of
  0.  After migration to DB2 Version 10 new-function mode, the
  length of a TIMESTAMP column is 10 and the scale is 6.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Warning message "CKZ54772W TABLE        *
  *                      COLUMN Mismatch, Attribute SCALE" may   *
  *                      be issued after migrating to DB2        *
  *                      version 10 new-function mode and above. *
  *                      This will address an issue where pre    *
  *                      DB2 Version 10 new-function mode,       *
  *                      TIMESTAMP columns have a length of 10   *
  *                      bytes and a scale of 0.  After          *
  *                      migration to DB2 Version 10             *
  *                      new-function mode, the length of a      *
  *                      TIMESTAMP column is 10 and the scale    *
  *                      is 6.                                   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI17728

Modules/Macros

• CKZ00547 CKZ00611 CKZ00612 CKZ00670 CKZ00671
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UI17728

     UP14/05/21 P F405

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.