search cancel

CA RC/Migrator for Db2 for z/os: Analysis unexpectedly dropping the tablespace due to changes in partition key columns.

book

Article ID: 215095

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

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

Cause

Changes in the partitioning key columns require a drop and recreate of the tablespace ,table and indexes.

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

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.