PK42718: GOC FOR COLUMN CHANGE TO ROWID NOT NULL GENERATED ALWAYS GENERATES INCORRECT DDL OF ROWID NOT NULL GENERATED BY DEFAULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using Object Compare to change a column to:
  rowid not null generated always
  does not generate the correct ddl.
     The incorrect create DDL shows:
   CREATE TABLE DAGOTEST.TEST02
      (COL1                 ROWID NOT NULL GENERATED BY DEFAULT,
  .
   If the user attempts to load or insert data they get
   sql code -540 sqlcoden540 sqlcode 540
  DSNT408I SQLCODE = -540, ERROR:  THE DEFINITION OF TABLE
     LUCYK.TEST02 IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX
       OR A REQUIRED UNIQUE INDEX
  
  DSNT418I SQLSTATE   = 57001 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXOTL SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -550  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFDDA'  X'00000000'  X'00000000'
  X'FFFFFFFF'
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The new table being  created with a     *
  *                      ROWID NOT NULL GENERATED BY DEFAULT     *
  *                      instead of  the the  expected ROWID     *
  *                      NOT NULL GENERATED ALWAYS.              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  The new table being created with a ROWID NOT NULL GENERATED BY
  DEFAULT  instead of the the expected  ROWID NOT NULL GENERATED
  ALWAYS.
  

Problem conclusion

•  For new tables Object Compare will not change "GENERATED ALWAYS
   to "GENERATED BY DEFAUL" specification.  Fixed in Object Compar
   V7.1 and V7.2.
  

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

•    GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK26715

     UP07/08/10 P F708

• R720 PSY UK26716

     UP07/08/10 P F708

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.