CA RC/Migrator for Db2 for z/os: Analysis unexpectedly dropping the tablespace due to changes in partition key columns.
Article ID: 215095
Updated On:
Products
Issue/Introduction
A Compare analysis script is unexpectedly dropping the tablespace. The report indicates changes to PARTKEYCOL_NUM. How can changes to the partition key columns be left out of the compare.
This is reported in the Change Analysis Report
Table Changes for:
Creator: authid
Name: table_name
Attribute Status Value
------------- ----------- ----+----1----+----2----+----3--
PARTKEYCOL Currently: 4
_NUM Changed To: 1
Environment
Release : 20.0
Component : CA RC/Migrator for DB2 for z/OS
Cause
Changes in the partitioning key columns require a drop and recreate of the tablespace ,table and indexes.
Resolution
In the RULESET, in the TABLE section, turn off any changes to partitioning:
PARTITIONING N
LIMITKEY_VALUES N
HONOR_HIGHKEY_ON_ICP2TCP N
This also means that ANY other changes to partitioning are also turned off.
After the above rules are changed to N on PARTITIONING the analysis will generate other changes found with ALTER's unstead unless there are other structural changes that require a drop and recreate.
Feedback
