PI55249: DB2 ADMINISTRATION TOOL FOR Z/OS EXTRACT PROCESS DOES NOT GENERATE ALL RELATED OBJECTS DURING CM PROCESS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS extract process does
  not GENerate all related objects when CREATEs for
  ALIAS, TABLE, VIEW and SYNONYM exist during
  CM ANALYZE and RUN
  

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: DB2 Administration Tool for z/OS        *
  *                      extract process does not generate all   *
  *                      related objects when creates for an     *
  *                      ALIAS, TABLE, VIEW and/or SYNONYM       *
  *                      exist during the Change Management      *
  *                      (CM) ANALYZE and RUN process.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program can not extract a SYNONYM, ALIAS, or TABLE from
  the DB2 subsystem for the target that has the same name
  as a VIEW in the change file which causes a SQLCODE=-601 /
  SQLCODEN601 error:
  
  DSNT408I SQLCODE = -601, ERROR:  THE NAME
  (VERSION OR VOLUME SERIAL NUMBER) OF
  THE OBJECT TO BE DEFINED OR THE TARGET OF A
  RENAME STATEMENT IS IDENTICAL TO THE EXISTING
  NAME (VERSION OR VOLUME SERIAL NUMBER)
  >object_name< OF THE OBJECT TYPE >object_type<
  DSNT418I SQLSTATE   = 42710
  SQLSTATE RETURN CODE
  

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:

  UI37472 UI37473

Modules/Macros

•    ADBCVOC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37472

     UP16/05/05 P F605

• RB20 PSY UI37473

     UP16/05/05 P F605

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.