How to generate an inline image copy for an IBM Reorg utility.

Document ID : KB000005966
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

On a DB2 v11 subsystem, an RC/Migrator Analysis is generating an IBM Reorg Utility followed by a standalone Image Copy. When the Reorg utility is executed it fails with the following error:

DSNU047I +DB2D 059 14:26:47.03 DSNURFIT - A REQUIRED DD CARD OR TEMPLATE IS 
MISSING. NAME=SYSCOPY 

The following Analysis Utility options have been specified:

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

REORG TS,IX,B,N    ==> B

Environment:
DB2 V11 and above.
Cause:

An inline image copy is required rather than a standalone image copy.

Resolution:

As this is a partitioned tablespace, you should set the Image Copy analysis option to 'P': 

Image Copy ===> P 

In batch, this can also be achieved by changing the PARMFILE control cards in the Analysis JCL as follow:

Add the PARTITION parameter to the IMAGCOPY card

IMAGCOPY PARTITION

This will provide partition independence and will generate an inline image copy in the Reorg utility.

 

 

 

 

Additional Information:

You can find further details on the Image Copy analysis option in the online help by hitting PF1 on the Analysis Options panel, 'RC/M ICL/Alter/Compare Strategy Analysis Options'.