RC/Migrator for DB2 for Z/OS : Alter Limits on a TCP

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

A user has a table with 132 partitions, each of which represents a month of data. The first partition has a limit of '2004-01-31' and the last one has a limit of '2014-12-31'.  The user wants to logically drop off the first 60 partitions and   
add 60 new ones to the end, and physically delete the data in the first 60 partitions and initialize the 60 new ones.  

 

 

Environment

Release: R20
Component: RCM

Resolution

Using RC/Migrator create an ALTER strategy for the table.  Once on the Table Alter screen, issue the LIMITS command first and then the limit keys will be displayed.

Then issue the ROTATE command and input the limitkey for the last partition. This should be repeated for each partition that is to be ROTATEed to include the new last partition.   

 

Additional Information

Modify the Partitions and Limit Key Values of a TCP Table