Joined: 26 Apr 2005
|We are trying to create an unload from a DB2 image copy.Currently we are using DSNUTILB program with the FROMCOPY parameter to create the unload. The exact jcl is shown below:
//UTIL EXEC DSNUPROC,SYSTEM=DB2A,UID='UNLOAD'
//ULDDDN DD DSN=unload.dataset,DISP=(NEW,CATLG,CATLG),
//PNHDDN DD DSN=unload.PUNCH,DISP=(OLD,CATLG,CATLG),
//SYSIN DD *
UNLOAD TABLESPACE tablespacename
PUNCHDDN PNHDDN UNLDDN ULDDDN
I was wondering if there is any other means by which we can create this unload from the imagecopy.
One more problem is , as the GDG version of the imagecopy keeps on changing daily, we have to change the SYSIN parameter daily.
One way around is to make a separate (temporary) copy of the latest GDG and use this copy in this step.(to avoid changing the SYSIN parameter everyday). But this requires both time and space.
Just wondering if there is any other way around this.