PI57749: CHANGE MANAGEMENT UNNECESSARY DROP ALIAS STATEMENTS DURING CM ANALYZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administraction Tool for z/OS' Change Management
  function built unnecessary DROP ALIAS statements during analyze.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use the Change             *
  *                 Management function to add new               *
  *                 Aliases.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When adding new Aliases to the          *
  *                      target DB2 system, a DROP ALIAS         *
  *                      statement was generated with a          *
  *                      SET ACCEPT_RC, SQLCODE=-204             *
  *                      / SQLCODEN204 statement prior to        *
  *                      creating the Alias.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When adding new Aliases to the target DB2 system, a DROP
  ALIAS statement was generated with a SET ACCEPT_RC,
  SQLCODE=-204 / SQLCODEN204 statement prior to creating the
  Alias:
  
  --SET ACCEPT_RC 0 -204
  DROP ALIAS <alias_schema>.<alias_name>
  CREATE ALIAS <alias_schema>.<alias_name>
  
  The purpose of the DROP ALIAS statement was intended for
  dangling a Alias which is not part of the compare /
  change scope. The DROP statement with the SET ACCEPT_RC
  statement ensures the new Alias be added successfully.
  However, dropping the Alias actually is not necessary
  when using Change Management because in the Change
  Management path the product always has the full scope
  of the objects that are affected by a change.
  

Problem conclusion

• The program has been modified to eliminate the attempt to drop
  the dangling Alias prior to adding a new Alias when analyzing
  a change using Change Management.  While in the classic Compare
  function, the DROP statement still remains to ensure the
  success of creating the new Alias.
  

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:

  UI38408 UI38409

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI38408

     UP16/06/09 P F606

• RB20 PSY UI38409

     UP16/06/09 P F606

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.