PH23141: GOC-ORIGINAL RECOVER SHOULD UNLOAD/RELOAD ALL OBJECTS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• GOC-ORIGINAL RECOVER SHOULD UNLOAD/RELOAD ALL OBJECTS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration and Object       *
  *                 Comparison Tool 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 object in         *
  *                      read-only state causes 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.                          *
  *                                                              *
  *                      3. If the compare process results in    *
  *                      an altered table, the necessary         *
  *                      UNLOAD statement for recovering         *
  *                      original data does not exist.           *
  *                                                              *
  *                      An additional issue occurs when         *
  *                      performing CM Analyze with "Generate a  *
  *                      recover change" = N, "Data to           *
  *                      recover" = O, and "Unload Method" = H   *
  *                      fails with FUNCTION = ADBGAJOB, LINE    *
  *                      4932: "TBTOP " coltab RC = 8 ZERRMSG =  *
  *                      ISPT034 ZERRSM = Novalue condition      *
  *                      raised for variable COLTAB ZERRLM =     *
  *                      Error executing EXEC - now terminating. *
  ****************************************************************
  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 in 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,
  the compare process results in an altered table, the
  necessary UNLOAD statement for recovering the original data does
  not exist. 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.
  
  An additional issue occurs when
  performing CM Analyze with "Generate a
  recover change" = N, "Data to recover" = O, and
  "Unload Method" = H results in NOVALUE CONDITION
  from ADBGAJOB function.
  
  COMMENTS-
  The problems are 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

• GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI68602

     UP20/05/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.