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:
Attribute Status Value
------------- ----------- ----+----1----+----2----+----3--
PARTKEYCOL Currently: 4
_NUM Changed To: 1
Changes in the partitioning key columns require a drop and recreate of the tablespace ,table and indexes.
Release : 20.0
Component : CA RC/Migrator for DB2 for z/OS
In the RULESET, in the TABLE section, turn off any changes to partitioning:
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.