PH17000: PANEL ADB2GEN "ALTER TABLE ADD FOREIGN KEY" VALUE NOT ALWAYS RETAINED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In panel ADB2GEN for "ALTER TABLE ADD FOREIGN KEY" option "D"
  is set. Running GEN line command for a table (or any other
  object) runs fine. But when running GEN line command on a
  view and subsequently running GEN on a table again option
  "D" is changed to "Y".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In panel ADB2GEN, "ALTER TABLE ADD      *
  *                      FOREIGN KEY" option value for TB is     *
  *                      reset if GEN line command is executed   *
  *                      on VW, then TB again.                   *
  *                      The following fields also have this     *
  *                      issue:                                  *
  *                      CREATE TABLE                            *
  *                      CREATE INDEX                            *
  *                      CREATE MASK                             *
  *                      CREATE PERMISSION                       *
  *                      GRANT access ON TABLE                   *
  *                      ALTER TABLE ACTIVATE CONTROL            *
  ****************************************************************
  In panel ADB2GEN, "ALTER TABLE ADD FOREIGN KEY" option value
  for TB is reset if GEN line command is executed on VW, then TB
  again.  The following fields also have this issue:
  
  CREATE TABLE
  CREATE INDEX
  CREATE MASK
  CREATE PERMISSION
  GRANT access ON TABLE
  ALTER TABLE ACTIVATE CONTROL
  

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:

  UI65733

Modules/Macros

• ADB2GEN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65733

     UP19/10/10 P F910

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.