PH06936: DB2 ADMIN TOOL - INCORRECT DROP STATEMENT FOR FOREIGN KEY, SQLCODE = -204

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the primary key index of a parent table is updated and the
  change requires the DROP/CREATE, recreation of primary key index
  causes AOC to generate WSL with:
  1) Drop primary key
  2) Drop index
  3) Drop foreign key
  
  Step 3 fails with SQLCODE = -204 / SQLCODEN204 because dropping
  a primary key automatically drops the definition of the primary
  key and all referential constraints in which the primary key is
  a parent key.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for z/OS *
  *                 who compare tables that have referential     *
  *                 constraints.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Compare generates a WSL that when     *
  *                      executed results in SQLCode -204 /      *
  *                      SQLCODEN204.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A Compare that drops the definition of the primary key,
  generates a WSL that explicitly drops the associated foreign
  keys which results in SQLCode -204. This is because dropping
  of the primary key drops the definition of the primary key and
  all referential constraints in which the primary key is a parent
  key.
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62948

     UP19/05/16 P F905

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.