PK20520: MIG OF A TABLE WITH A ROWID NOT NULL GENERATED ALWAYS COLUMN FAILS IN THE LOAD STEP WITH MESSAGE DSNU309I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool MIG function fails in the LOAD step
  with a message DSNU309I DSNU309I  #DSN8- DSNUROFL - NOT ALL
  REQUIRED UNIQUE INDEXES HAVE BEEN DEFINED FOR TABLE
  when a table with a column defined as ROWID NOT NULL GENERATED
  ALWAYS is selected as the column is defined as GENERATED BY
  DEFAULT when the table is created.
  If an unique index exist for column the MIG jobs fail to ALTER
  the column back to GENERATED ALWAYS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 Migrate function, may be affected.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Migrate  of  a  Table with a  ROWID NOT *
  *                      NULL  GENERATED  ALWAYS  COLUMN   fails *
  *                      in the LOAD step with message  DSNU309I *
  *                      .*                                      *
  *                      The MIGRATE function fails in  the LOAD *
  *                      step  with  a  message DSNU309I  when a *
  *                      table with  a  column defined as  ROWID *
  *                      NOT NULL GENERATED ALWAYS  is  selected *
  *                      as the column  is defined as  GENERATED *
  *                      BY DEFAULT  when the table is  created. *
  *                      If  an  unique index exists for  column *
  *                      the MIG jobs fail  to ALTER the  column *
  *                      back to GENERATED ALWAYS.               *
  *                      .*                                      *
  *                      Migrate  uses a special GEN  process to *
  *                      convert  GENERATED ALWAYS to  GENERATED *
  *                      BY DEFAULT  for all ROWID and  IDENTITY *
  *                      columns in CREATE TABLE statements.  It *
  *                      does  this  by  passing  COLCTRL  as  a *
  *                      parameter.  This   fix   modifies   the *
  *                      scenario so  that SET CURRENT  RULES  = *
  *                      'STD'; is generated before these CREATE *
  *                      TABLE statements, and SET CURRENT RULES *
  *                      = 'DB2';  is  generated after. This  is *
  *                      only done when COLCTRL is  a parameter, *
  *                      and when there  is  at least one column *
  *                      in  the  table which is either ROWID or *
  *                      IDENTITY,  and   has   a   default   of *
  *                      GENERATED ALWAYS.                       *
  ****************************************************************
  * 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

•    ADB2REG  ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK13525

     UP06/04/19 P F604

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.