Help on RC/Migrator (moving one partition's data from prod to test)

Philip Nelson

Help on RC/Migrator (moving one partition's data from prod to test)
Not strictly DB2, but using a DB2 tool. Hopefully I can get a quick
answer from a user who has done this already. I guess that will be
quicker than going through Tech Support (although I will raise the call
anyway).

We have the CA/Platinum tools and want to achieve the following in
RC/Migrator.

Our data warehouse has 36 partitions (36 months worth of data) for
certain tablespaces.

A developer wants a test database with only the latest month's data.

So we need to :

Copy tablespaces (but change from partitioned to non-partitioned with
the size being equal to the size of one partition).

Copy all tables / indexes and the like, getting rid of partitioning keys
and any other "partition type" references.

Extract and move data from one partition of production into the new
structure.

Is this possible automatically using RC/Migrator ?



Mike Holmans

Re: Help on RC/Migrator (moving one partition's data fro m prod to test)
(in response to Philip Nelson)
Philip,

I don't think you can get that generated automatically by RC/M.

Wouldn't it be simpler, though, to copy the structure across as is, but edit
down the sizes of the other 35 partitions to nominal one-track efforts? You
can do that in RC/M reasonably easily, although it's a little laborious.

Mike Holmans
Database Consultant
BT Affinitis Computing Partners
[login to unmask email]

This post is solely the opinion of its author and does not necessarily
reflect BT's view


>>-----Original Message-----
>>From: Philip Nelson (DBA) [mailto:[login to unmask email]
>>Sent: Tuesday, December 18, 2001 11:22 AM
>>To: [login to unmask email]
>>Subject: [DB2-L] Help on RC/Migrator (moving one partition's data from
>>prod to test)
>>
>>
>>Not strictly DB2, but using a DB2 tool. Hopefully I can get a quick
>>answer from a user who has done this already. I guess that will be
>>quicker than going through Tech Support (although I will
>>raise the call
>>anyway).
>>
>>We have the CA/Platinum tools and want to achieve the following in
>>RC/Migrator.
>>
>>Our data warehouse has 36 partitions (36 months worth of data) for
>>certain tablespaces.
>>
>>A developer wants a test database with only the latest month's data.
>>
>>So we need to :
>>
>>Copy tablespaces (but change from partitioned to non-partitioned with
>>the size being equal to the size of one partition).
>>
>>Copy all tables / indexes and the like, getting rid of
>>partitioning keys
>>and any other "partition type" references.
>>
>>Extract and move data from one partition of production into the new
>>structure.
>>
>>Is this possible automatically using RC/Migrator ?
>>
>>
>>To change your subscription options or to cancel your
>>subscription visit the DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]