PK18883: GEN FIX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN fix
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Administration Tool, who      *
  *                 use  DB2 Object Comparison Tool to have      *
  *                 the Target automatically generated from      *
  *                 the Source, may be affected.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following problems are addressed:   *
  *                      Delay  generation  of  explicit aliases *
  *                       and synonyms                           *
  *                      Extra GRANTs for VIEWS                  *
  *                      CREATE AUX TABLE missing COLUMN keyword *
  *                      .*                                      *
  *                      In the scenarios  where  the target  is *
  *                      automatically   generated    from   the *
  *                      source,  view   and   MQT  synonyms and *
  *                      aliases  are   identified  by   ADBCVOB *
  *                      and become a part of the  GEN requests. *
  *                      Currently  (before   the  fix),   these *
  *                      requests  are  processed  first, before *
  *                      the views and MQTs to which they belong *
  *                      This resulted  in  out-of-place synonym *
  *                      and  alias  records  in  the  resulting *
  *                      Version File, and Object Compare errors *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ADB2REE, ADB2REM, ADB2REP, ABD2RECA, and ADB2REWA have been
  changed to correct the problems.
  

Problem conclusion

• ADB2REE, ADB2REM, ADB2REP, ABD2RECA, and ADB2REWA have been
  changed to correct the problems.
  

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

•    ADB2RE   ADB2REE  ADB2REG  ADB2REM  ADB2REP
  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK13140

     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.