DB2 Utilities- Unload Image Copy Dataset.

Sample Job:

//UTIL EXEC DSNUPROC,SYSTEM=DSNS,UID='TEMP',UTPROC=''

//**********************************************

//* UNLOADING IMAGE COPY DATASET

//**********************************************

//DSNUPROC.SYSREC DD DSN=USERID.SRI.SYSREC,

// DISP=(MOD,CATLG),

// SPACE=(16384,(20,20),,,ROUND),

// UNIT=SYSALLDA

//DSNUPROC.SYSPUNCH DD DSN=USERID.SRI.SYSPUNCH,

// DISP=(MOD,CATLG),

// SPACE=(16384,(20,20),,,ROUND),

// UNIT=SYSALLDA

//DSNUPROC.SYSIN DD *

UNLOAD TABLESPACE DBNAME.TSNAME FROMCOPY USERID.SRI.DATA;

If the table was dropped, its not possible to Unload data from the Image copies. You will receive the following error message.

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC

DSNU050I DSNUGUTC - UNLOAD TABLESPACE DBNAME.ZSRIDHAR

DSNU260I -DSNS DSNUULIA-TABLESPACE DBNAME.ZSRIDHAR IS EMPTY

DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4