Page 1 of 1

Unload from IC

PostPosted: Tue Jul 05, 2011 8:59 pm
by p19689
Hi , I used BMC change manager to create mass unloads from ICs. Is it possible to create unloads for many tables from full image copy via IBM admin tool. What's the most efficient way of doing this for many number of tables please ? Thanks inadvance.

Re: Unload from IC

PostPosted: Tue Jul 05, 2011 10:45 pm
by dick scherrer
Hello,

I used BMC change manager to create mass unloads from ICs.
You might edit these to the non-BMC utility statement format. . .


//UTIL     EXEC DSNUPROC,SYSTEM=SSID,UID='UNLOAD'
//ULDDDN   DD DSN=UNLOAD.DATASET,DISP=(NEW,CATLG,CATLG),
//        UNIT=SYSDA,SPACE=(CYL,(100,100),RLSE) DCB=MODEL
//PNHDDN DD DSN=UNLOAD.PUNCH,DISP=(NEW,CATLG,CATLG),
//        UNIT=SYSDA,SPACE=(TRK,(5,5),RLSE) 
//SYSIN DD *
UNLOAD TABLESPACE DBNAME.TBNAME
FROMCOPY <Image copy dataset name>
PUNCHDDN PNHDDN UNLDDN ULDDDN
/*


Keep in mind you must have at least SELECT permission for the table. . .

Re: Unload from IC

PostPosted: Wed Jul 06, 2011 8:21 pm
by p19689
Many thanks, my problem is I need to create these job cards for thousnad of tablespaces. Can DB2 admin tool do that ?

Re: Unload from IC

PostPosted: Thu Jul 07, 2011 5:34 pm
by p19689
I found it ! Can use MIG command to create unload/loads for many objects.

Re: Unload from IC

PostPosted: Thu Jul 07, 2011 10:47 pm
by dick scherrer
Cool - thank you for letting us know :)

d