PM16847: MIG FUNCTION ROWID COLUMNS CHANGED FROM GENERATED ALWAYS TO GENERATED BY DEFAULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS MIG function changes
  ROWID columns from GENERATED ALWAYS to GENERATED BY DEFAULT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Migrate (MIG) function to   *
  *                 migrate a table which contains a ROWID,      *
  *                 IDENTITY or ROW CHANGE TIMESTAMP column      *
  *                 defined as GENERATED ALWAYS.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool MIG         *
  *                      function changes the ROWID, IDENTITY    *
  *                      and ROW CHANGE TIMESTAMP columns from   *
  *                      GENERATED ALWAYS to GENERATED BY        *
  *                      DEFAULT.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool MIG function changes the ROWID,
  IDENTITY and ROW CHANGE TIMESTAMP columns from GENERATED ALWAYS
  to GENERATED BY DEFAULT.
  

Problem conclusion

• Program has been modified to provide more options to the user.
  The user is able to control whether to retain GENERATED ALWAYS
  for the ROWID and ROW CHANGE TIMESTAMP columns when data is
  being migrated.
  
  These fields have been added to panel ADB28M "Migrate
  Parameters"
  
  Retain GENERATED ALWAYS:
      For ROWID . . . . . . . . . . . . . . . . . :   YES/NO
      For ROW CHANGE TIMESTAMP. . . . :         YES/NO
  
  For the IDENTITY column, MIG will retain GENERATED ALWAYS
  and use IDENTITYOVERRIDE to load the column data from
  the source to target.
  

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:

  UK67517

Modules/Macros

•    ADBH8M   ADB2GEN  ADB2RE   ADB2REE  ADB2REG
  ADB2REM  ADB2REU  ADB2REZ  ADB28M   ADB28MC  ADB28MCT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK67517

     UP11/05/11 P F105

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.