PH38600: GOC - RECOVER SHOULD UNLOAD ALL ALTERED TABLE CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• GOC - Recover should unload all altered table changes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS and Db2 Object Comparison           *
  *                 Tool for z/OS who use Change                 *
  *                 Management (CM) to recover a change.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR updates the functionality of  *
  *                      the CM analyze options "Unload Altered  *
  *                      Tables" and "Recreate for NULLS         *
  *                      Change," and the corresponding CM batch *
  *                      options unload_altered_tables and       *
  *                      recreate_for_nulls_change.              *
  ****************************************************************
  1. Previously, when using Change Management and analyzing
  changes, the recover option "Unload Altered Tables"= Y did not
  determine whether UNLOAD statements were generated. This
  setting forced an ALTER operation instead of DROP and CREATE
  operations if possible. This APAR changes the "Unload Altered
  Tables" option, so that it now controls whether UNLOAD
  statements are generated for altered tables. Additionally, the
  choice of whether to use ALTER instead of DROP and CREATE is
  now made independently of the value of the "Unload Altered
  Tables" option.
  
  2. In situations where a table column is dropped, compare
  results in a non-destructive ALTER statement now and requires
  a REORG operation. It is recommended for the user to either
  specify "Run REORG/REBUILD" = A or M option on panels GOC5
  (Compare) or ADB2C11A (Analyze), OR the run_reorg_rebuild = A
  or M CM Batch parameter, along with SHRLEVEL = CHANGE or
  REFERENCE, in order to materialize the change. In the absence
  of a REORG, subsequent ALTERs on the same objects will fail
  with SQLCODE -20385.
  
  3. Previously, the "Unload Altered Tables" option was forced
  to "YES" when recovering to either original or existing data.
  This APAR changes this behavior so that this option is forced to
  "YES" only when recovering to original data.
  
  4. With this APAR, the CM analyze option "Recreate for NULLS
  Change" is renamed "Preserve all data," and the corresponding
  CM batch option recreate_for_nulls_change is renamed
  preserve_all_data. "Preserve all data" = NO allows a NULL
  column change as an ALTER operation instead of DROP and
  CREATE operations. Previously, the "Recreate for NULLS
  Change" option was applicable only if "Unload Altered Tables"
  was set to Y. With this APAR, the renamed option "Preserve
  all data" is independent of the "Unload Altered Tables" option.
  
  5. Previously, unnecessary UNLOAD statements were generated
  when recovering to original data during the RECOVER step. With
  this APAR, UNLOAD statements are generated for the Run step
  only.
  
  6. This APAR changes the default value of CM Batch LOAD utility
  option util_load_enforce from YES (ENFORCE CONSTRAINTS)
  to NO (ENFORCE NO), because, if both child and parent tables
  are unloaded, dropped, recreated, and loaded, the tables may not
  be loaded in the correct sequence (parent tables first).
  If the child table gets loaded first, running with ENFORCE
  CONSTRAINTS will result in an empty child table because there
  are no corresponding parent rows.
  Recommendation: only use ENFORCE CONSTRAINTS if the change does
  not require a recreate of both the parent and child tables.
  

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:

  UI76400

Modules/Macros

• GOCCMP   GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI76400

     UP21/07/23 P F107

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.