PK34053: GOC GENERATES DROP CREATE OF A TABLE WHEN IT SHOULD HAVE DONE A ALTER TABLE OR SMART ALTER WHEN CHANGING A COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer changes a column of a table and GOC runs to rc=0 and
  generates:
    Compare table source(xxx.yyyy) and target(xxx.yyyy)
      Column C35282
        (D)Field START changed from 1 to '
               0000000000000000000000000000000'
      Tables have identical column lists
      Table xxx.yyyy will be dropped
      Table will be recreated
  result should have been to do a 'smart' Alter Table
  

Local fix

• Please apply the ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 alter Identity column in DB2 V8,  may be     *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Changes to  Identity column cause table *
  *                      to  be  dropped/recreated  instead of a *
  *                      'Smart Alter'.                          *
  *                      .*                                      *
  *                      "Smart Alter"  should  be generated for *
  *                      Identity   column  changes  except  for *
  *                      'START' changes.                        *
  *                      .*                                      *
  *                      Changing START values is not supported. *
  *                      A message  will be issued in the Object *
  *                      Compare report.                         *
  *                      .*                                      *
  *                      If  'NO CYCLE'  is changed to 'CYCLE' a *
  *                      warning  message  in the report will be *
  *                      issued   about   a  possible  duplicate *
  *                      values  for  an Identity  column in the *
  *                      future.                                 *
  ****************************************************************
  * 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

•    GOC2CMF  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK21799

     UP07/02/06 P F702

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.