PI20177: DB2 ADMINISTRATION TOOL FOR Z/OS CHANGE MANAGEMENT DOES NOT SPECIFY INFORMATION WHEN DEALING WITH IDENTITY VALUES CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Change Management does not
  specify enough information when dealing with IDENTITY values
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who specify value 'Computed' for    *
  *                 field 'IDENTITY START value' on panel        *
  *                 GOC5 'Generate Compare Jobs' for a table     *
  *                 containing an identity column, and there     *
  *                 are changes on a table causing the table     *
  *                 to be dropped and recreated.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a table containing an     *
  *                      identity column, and the table needs    *
  *                      to be dropped and recreated after       *
  *                      specifying 'Computed' for the field     *
  *                      IDENTITY START value' on panel GOC5,    *
  *                      the verification step in the Compare    *
  *                      job failed with RC=8 / Return Code 8,   *
  *                      and an error message ADBC099E /         *
  *                      msgadbc099e is displayed in the         *
  *                      job log:                                *
  *                                                              *
  *                      ADBC099E: WSL mismatch.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If 'Computed' is specified for 'IDENTITY START value' field, the
  computed value will be based upon the existing identity column
  attributes at the time the DDL is produced, such as MAXASSIGNED
  and the current cache size. Any changes made after the creation
  of the DDL, to either the identity values or to the data, are
  not reflected in the DDL, and as a result, the DDL is obsolete.
  The product will not locate an unassigned value from the
  existing data, and ultimately a new RESTART value might need
  to be provided based upon the underlying data and the
  application needs. So, if the computed value for the identity
  column was different from its real value, the verification step
  will fail with the error message ADBC099E /msgadbc099e as
  expected.  The user should provide the correct start value of
  the identity column to avoid the failure .
  

Problem conclusion

• The description of 'IDENTITY START value' field on help panel
  GOC5H 'HELP: Generate Compare Job' has been improved.  A note
  was added to explain the computed value:
  
  Note:
  If Computed is specified, the computed value will be based
  upon the existing identity column attributes at the time the
  DDL is produced, such as MAXASSIGNED and the current cache size.
  Any changes made after the creation of the DDL, to either the
  identity values or to the data, are not reflected in the DDL
  and, make the DDL obsolete.  The product will not locate an
  unassigned value from the existing data, and ultimately a
  new RESTART value might need to be provided based upon the
  underlying data and the application needs.
  

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:

  UI19665 UI19666

Modules/Macros

•    GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UI19665

     UP14/07/18 P F407

• RB10 PSY UI19666

     UP14/07/21 P F407

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.