PI51990: SEQUENCE NOT BEING RETAINED WHEN CHANGE REQUIRES THE TABLE TO BE DROPPED/CREATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Change Management function
  used by the DB2 Object Comparison Tool for z/OS does not retain
  the correct SEQUENCE when the change requires the table be
  dropped and created.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who change a table with        *
  *                 an IDENTITY column or insert an              *
  *                 IDENTITY column into the table.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DB2 Object Comparison    *
  *                      Tool for z/OS to drop and re-create     *
  *                      a table which has an IDENTITY           *
  *                      column, or to insert a new IDENTITY     *
  *                      column to the table, the START          *
  *                      value of the IDENTITY column in         *
  *                      the DDL used to re-create the           *
  *                      table was computed based upon the       *
  *                      identity column attributes of the       *
  *                      source catalog if panel GOC5 'Generate  *
  *                      Compare Jobs' option 'IDENTITY START    *
  *                      value' is set to 'Computed' and the     *
  *                      source is selected from the DB2         *
  *                      catalog.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the DB2 Object Comparison Tool for z/OS to drop and
  re-create a table which has an IDENTITY column, or to insert a
  new IDENTITY column to the table, the START value of the
  IDENTITY column in the DDL used to re-create the table was
  computed based upon the identity column attributes of the
  source catalog if panel GOC5 'Generate Compare Jobs' option
  'IDENTITY START value' is set to 'Computed' and the source
  is selected from the DB2 catalog.
  

Problem conclusion

• Problem has been fixed. When panel GOC5 option 'IDENTITY START
  value' is set to 'Computed', the START value is always computed
  based upon the identity column attributes of the target
  catalog.  If the identity column does not exist on the target
  prior to the change, then the original START value of the
  source identity column will be used to re-create the target
  table.
  
  10.2:
  The DB2 Object Comparison Tool User's Guide and Reference,
  Version 10, Release 2 has been updated:
  
  DB2 Object Comparison Tool V10.2
    >Creating DB2 Object Comparison Tool batch jobs
       >Generating a compare batch job
         >Generate compare job options
  
  
  http://www-01.ibm.com/support/knowledgecenter/SSAUVH_10.2.0/
  topics/gocurgen1.htm
  
  11.1:
  The DB2 Object Comparison Tool User's Guide and Reference,
  Version 11, Release 1 has been updated:
  
  DB2 Object Comparison Tool V11.1
    >Creating DB2 Object Comparison Tool batch jobs
       >Generating a compare batch job
         >Generate compare job options
  
  http://www-01.ibm.com/support/knowledgecenter/SSAUVH_11.1.0/
  topics/gocurgen1.htm
  
  V11.2:
  The DB2 Object Comparison Tool User's Guide and Reference,
  Version 11, Release 2 has been updated:
  
  DB2 Object Comparison Tool V11.2
    >Creating DB2 Object Comparison Tool batch jobs
       >Generating a compare batch job
         >Generate compare job options
  
  http://www-01.ibm.com/support/knowledgecenter/SSAUVH_11.2.0/
  topics/gocurgen1.htm
  

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:

  UI34949 UI34950 UI34951

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI34949

     UP16/02/04 P F602

• RB10 PSY UI34950

     UP16/02/04 P F602

• RB20 PSY UI34951

     UP16/02/04 P F602

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.