PH36418: UPDATES TO CHANGE MANAGEMENT ANALYZE OPTIONS UNLOAD ALTERED TABLES AND RECREATE FOR NULLS CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• This APAR updates the CM Analyze options "Unload Altered Tables"
  and "Recreate for Nulls Change", including a rename of the
  latter option to "Preserve all data."
  

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:

  UI76402

Modules/Macros

• ADB2000  ADB2C11A ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2PCO
  ADB2UCUU ADB7000  ADBCCM   ADBCMBIV ADBEALT  ADBEMTAR ADBGAJOB
  ADBHPCO  ADBSALT  ADBSPCO  ADBTEP2  ADBTIMC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76402

     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.