PI16299: MISSING DB2 LOAD UTILITY SYNTAX ( MIXED KEYWORD ) DATA CORRUPTIO N WHEN CHANGING COLUMN FROM NULLABLE WITH DEFAULT TO NOT NULL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool for z/OS produced DB2 LOAD
  syntax which was missing the MIXED keyword when changing a
  column definition from nullable with default to not null in
  a MIXED YES environment.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 change a table which contains columns with   *
  *                 mixed data and the change causes the         *
  *                 table to be dropped and re-created.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using DB2 Administration Tool for  *
  *                      z/OS or DB2 Object Comparison Tool      *
  *                      for z/OS to drop and re-create a        *
  *                      table which contains columns with       *
  *                      mixed data, the generated LOAD          *
  *                      control statement was missing the       *
  *                      MIXED keyword for the fields with       *
  *                      mixed data. Data corruption may         *
  *                      occur after running the LOAD.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using DB2 Administration Tool for z/OS or DB2 Object
  Comparison Tool for z/OS to drop and re-create a table which
  contains columns with mixed data, the generated LOAD control
  statement was missing the MIXED keyword for the fields with
  mixed data. Data corruption may occur after running the LOAD.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI18325 UI18326 UI18327

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI18325

     UP14/05/28 P F405

• RA20 PSY UI18326

     UP14/05/28 P F405

• RB10 PSY UI18327

     UP14/05/28 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.