IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to copy Tape dataset to unix mainframe?


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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: 8574
Location: Dubuque, Iowa, USA

PostPosted: Fri Jul 08, 2016 6:44 am
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
Reply with quote

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

Global Moderator


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

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

How about this :

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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. copy file 2 data into file1 for match... DFSORT/ICETOOL 4
No new posts Mainframe developer resources/communi... COBOL Programming 2
No new posts ADR324E-VOL/DATASET SPECIFIED BY DDNA... JCL & VSAM 6
No new posts Prod parallel execution on mainframe ... CICS 1
No new posts Mainframe batch Job or REXX to get VT... CLIST & REXX 7
Search our Forums:

Back to Top