MVSFORUMS.com

[rrv]

Hi

In our shop, we recently migrated CA-Platinum for DB2 to IBM utilities. Some of the production table-spaces are partitioned, and CA-Platinum earlier provided options to recover the entire partitioned table space OR an individual partition. This was the preferred method to restore data from production to test sub-systems.

With IBM, we use DSN1COPY to copy production image copy datasets directly to the test DB2 VSAM data set of the required table space. DSN1COPY, to my knowledge, provides only two options for this purpose:

1) Input dataset is an image copy of a single partition -> Loads SPECIFIC partition
2) Input dataset is an image copy of an entire partitioned table space -> Loads ALL partitions

The question is - What are the methods to restore a specific partition using is an image copy of an entire partitioned table space ?
Appreciate your ideas. Thanks.

[kolusu]

rrv,

Read this topic for a detailed explanation of DSN1COPY

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGK10/3.8?

See example 5 for restoring a specific partition from a full image copy

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGK10/3.8.4?

Kolusu

[rrv]

Kolusu

Thanks for your quick reply.

I did see this example earlier, but what I am looking at specifically is for the SYSUT1 input data set as a full image copy of THE ENTIRE PARTITIONED TABLE SPCE. That is, COPY performed using DSNUM ALL. Example 5 of DSN1COPY indicates two different SYSUT1 datasets PART1501 & PART1502 for individual partition recovery. While both of these are FULL image copies, they are specific for a partition.

Are there any other options available for this purpose?

Thanks.
Ram