IBM Mainframe Forum

by **p19689** » Tue Jul 05, 2011 8:59 pm

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.

by **dick scherrer** » Tue Jul 05, 2011 10:45 pm

Hello,

I used BMC change manager to create mass unloads from ICs.

You might edit these to the non-BMC utility statement format. . .

Select all

//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. . .

by **p19689** » Wed Jul 06, 2011 8:21 pm

Many thanks, my problem is I need to create these job cards for thousnad of tablespaces. Can DB2 admin tool do that ?

by **p19689** » Thu Jul 07, 2011 5:34 pm

I found it ! Can use MIG command to create unload/loads for many objects.

by **dick scherrer** » Thu Jul 07, 2011 10:47 pm

Cool - thank you for letting us know

d

IBM Mainframe Forum

Unload from IC

Unload from IC

Re: Unload from IC

Re: Unload from IC

Re: Unload from IC

Re: Unload from IC