How to copy Tape dataset to unix mainframe?

chaky · New User Joined: 28 May 2009 Posts: 20 Location: Bangalore

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.

Robert Sample · Posted: Fri Jul 08, 2016 6:44 am

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

chaky · New User Joined: 28 May 2009 Posts: 20 Location: Bangalore

okay, thanks.

PeterHolland · Posted: Fri Jul 08, 2016 11:27 am

How about this :

ibmmainframes.com/about61487.html

chaky · New User Joined: 28 May 2009 Posts: 20 Location: Bangalore

PeterHolland - that was my post

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.