Unload from IC



IBM's flagship relational database management system

Unload from IC

Postby 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.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload from IC

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


//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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Unload from IC

Postby 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 ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload from IC

Postby p19689 » Thu Jul 07, 2011 5:34 pm

I found it ! Can use MIG command to create unload/loads for many objects.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload from IC

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

Cool - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post