When generating an Image Copy utility in the Analysis how do I copy all partitions in a single copy?

Document ID : KB000013503
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When generating an Image Copy utility in the Analysis how do I copy all partitions in a single copy? RC/Migrator is currently generating image copies by partition.

COPY TABLESPACE dbname.tsname DSNUM 1

  COPYDDN SYSCP001                    

COPY TABLESPACE dbname.tsname DSNUM 2

  COPYDDN SYSCP002                    

COPY TABLESPACE dbname.tsname DSNUM 3

  COPYDDN SYSCP003                    

Answer:

If partition independence is not required and you wish to copy all partitions of a Tablespace in a single image copy, then Image Copy analysis option 'Y' is required.

IMAGE COPY (Y,P,N) ==> Y

With this option and the generated PARMFILE parameter, IMAGCOPY, the image copy utility will be generated as a standalone utility, copying all partitions with DSNUM ALL in a single image copy.

COPY TABLESPACE dbname.tsname DSNUM ALL
COPYDDN SYSCPDDN

                       

 

Additional Information:

With regards to whether to specify 'P' or 'Y' for the Image Copy analysis option, these values are described as follows:

Y (run the COPY utilty and generate image copy control cards for all partitions of all tablespaces or indexspaces involved in an alteration).

P (run the COPY utility with partition independence. This option generates image copy control cards only for altered partitions of tablespaces or indexespaces involved in an alteration). 
If P is specified, all partitions are copied for partition by growth universal tablespaces.

N (do not run the COPY utility). N is the default. 

 

The following chart is available in the online help for the RC/M Migrate Strategy Analysis Options panel (PF1)

Capture.JPG

 

 

Further details on the Utility analysis options can be found at AnalysisOptions-UtilityOptions.