PH21635: CM GENERATE RECOVER CHANGE INCONSISTENT RECOVERY POINT; ALTER DUPLICATE DATA; UNLOAD NOT GENERATED FOR ALTERED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The following issues may occur when
  performing CM Analyze with "Generate a
  recover change" = Y or
  generate_recover_change = yes for CM
  Batch:
  
  1. If multiple objects are recovered with the
  original data, staggered statements to
  set the objects in read-only state may cause
  a possible inconsistent recovery point.
  
  2. If objects can be recovered by an
  ALTER statement, the original data is
  loaded without the existing data
  being removed, resulting in duplication
  of data.
  
  3. If the compare process results in
  an altered table, the necessary
  UNLOAD statement for recovering
  original data is not generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS and Db2 Object Comparison           *
  *                 Tool for zOS who use Change                  *
  *                 Management (CM) to recover a change.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues occur when         *
  *                      performing CM Analyze with "Generate a  *
  *                      recover change" = Y or                  *
  *                      generate_recover_change = yes for CM    *
  *                      Batch:                                  *
  *                                                              *
  *                      1. If multiple objects are recovered    *
  *                      with the original data, staggered       *
  *                      statements to set the objects in        *
  *                      read-only state may cause               *
  *                      a possible inconsistent recovery point. *
  *                                                              *
  *                      2. If objects can be recovered by an    *
  *                      ALTER statement, the original data is   *
  *                      loaded without the existing data        *
  *                      being removed, resulting in duplication *
  *                      of data.                                *
  *                                                              *
  *                      3. If the compare process results in    *
  *                      an altered table, the necessary         *
  *                      UNLOAD statement for recovering         *
  *                      original data is not generated.         *
  ****************************************************************
  The following issues occur when performing CM Analyze with
  "Generate a recover change" = Y or generate_recover_change = yes
  for CM Batch:
  
  1. When using Change Management and recovering multiple objects
  with the original data, the objects are placed in a read-only
  state in a staggered time frame, which causes an inconsistent
  recovery point. All objects should be placed in a read-only
  state before any data is unloaded.
  
  2. When using Change Management and recovering with the original
  data, ALTER operations that are done as part of the recover
  change might result in the duplication of data. The data needs
  to be removed before the original data is loaded.
  
  3. When performing CM Analyze and generating a recover change,
  and the compare process results in an altered table, the
  necessary UNLOAD statement for recovering the original data is
  not generated. When analyzing a change that results in dropping
  columns or adding columns by using table ALTER operations, an
  UNLOAD statement should be generated. A future enhancement will
  generate an UNLOAD statement for any column ALTER operation.
  
  NOTE:  The following additional error may occur when performing
  CM Analyze with "Generate a recover change" = N, "Data to
  recover" = O, and "Unload Method" = H:
  
  FUNCTION = ADBGAJOB, LINE 4932: "TBTOP " coltab RC = 8
  ZERRMSG =ISPT034
  ZERRSM = Novalue condition raised for variable COLTAB
  ZERRLM =
  Error executing EXEC - now terminating.
  
  COMMENTS-
  The problems have been resolved.
  

Problem conclusion

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

• ADB2C11A ADB2CMT  ADB2CMU  ADB2PCO  ADB2WCM  ADB7000  ADBCCM
  ADBCDTS  ADBGAJOB ADBHPCO  ADBTEPU  ADBTTP   ADBTUNL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI68601

     UP20/04/02 P F004

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.