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.
Joined: 06 Jun 2008 Posts: 8455 Location: Dubuque, Iowa, USA
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).