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
 

 

How to copy Tape dataset to unix mainframe?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
chaky

New User


Joined: 28 May 2009
Posts: 20
Location: Bangalore

PostPosted: Fri Jul 08, 2016 2:52 am    Post subject: How to copy Tape dataset to unix mainframe?
Reply with quote

Hello,

We have a requirement in the migration project where we need to SFTP the dump of a DB2 table to some other destination. As the DB2 dump is huge, I am saving it on Tape and not on DASD. I am also able to do SFTP this Tape file by using option mount. But the problem is that this SFTP takes around 4 to 5 hours.

So I realized I could optimize this by having the file on unix mainframe and compress it and then do the SFTP. But the oput command in unable to work on the Tape file. It is working fine on the DASD files. I know a normal suggestion would be that save the file on DASD, transfer it on unix and then do the compress. Is there some direct command like oput where I can directly put the Tape file to unix mainframe? Below is what working with the DASD file and not with the Tape files.

Code:
oput 'USERID.TABLE.DUMP' '/home/userdata/export/tabledump.txt'
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Fri Jul 08, 2016 6:44 am    Post subject:
Reply with quote

Neither the Unix System Services Command Reference nor the User's Guide have the word "tape" in their index. Unless you can get DB2 to compress the dump as it is created, you're going to have to live with the 4-5 hour transfer time, talk to your site support group about getting space on disk for the data set (there is no such thing on the mainframe as a "DASD file" -- either they are data sets or tape files or Unix files, period), or see if there are any third party products to do what you want (which will cost your organization money).
Back to top
View user's profile Send private message
chaky

New User


Joined: 28 May 2009
Posts: 20
Location: Bangalore

PostPosted: Fri Jul 08, 2016 8:11 am    Post subject:
Reply with quote

okay, thanks.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jul 08, 2016 11:27 am    Post subject:
Reply with quote

How about this :

http://ibmmainframes.com/about61487.html
Back to top
View user's profile Send private message
chaky

New User


Joined: 28 May 2009
Posts: 20
Location: Bangalore

PostPosted: Fri Jul 08, 2016 6:01 pm    Post subject:
Reply with quote

PeterHolland - that was my post icon_smile.gif

Issue in that post was different, there I was not able to SFTP the fle on Tape, later I found that it can be done by using option "mount" in Cozbatch options and implemented successfully.

Here size of the Tape file is so big that I want to zip it on unix and then do the SFTP. But I am unable to put the Tape file on unix mainframe.
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 -> All Other Mainframe Topics 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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 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 JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm


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