Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Unloading from a DB2 image copy

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
naive

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Thu Jun 09, 2005 3:42 am    Post subject: Unloading from a DB2 image copy
Reply with quote

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),
// UNIT=SYSDA,SPACE=(CYL,(1,1),RLSE),DCB=MODEL
//PNHDDN DD DSN=unload.PUNCH,DISP=(OLD,CATLG,CATLG),
// UNIT=SYSDA,SPACE=(TRK,(5,5),RLSE),DCB=MODEL
//SYSIN DD *
UNLOAD TABLESPACE tablespacename
FROMCOPY Imagecopyname
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.
Back to top
View user's profile Send private message

MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Thu Jun 09, 2005 6:00 pm    Post subject:
Reply with quote

Try with this help from IBM.
You can specify the FROMCOPYDDN and specify in your jcl the gdg with the last version (0).
http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.db2.doc.ugref/bjnbmstr35.htm
I hope in this help.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us