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

How to download/FTP the TAPE files into Windows - DB2


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kumarramky

New User


Joined: 04 Aug 2006
Posts: 5

PostPosted: Thu Nov 23, 2006 9:45 pm
Reply with quote

Hi there,

I have a mainframe tape file which contains 10 millions records and I would like to Load this into DB2 UDB dataase which is running on windows.

Can anyone of you please help me on how to download/FTP this TAPE file into local machine?

Thanks.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Nov 24, 2006 8:40 am
Reply with quote

I don't know anything about DB2, but FTP is a relatively straight-forward process, and obviously with 10 million records it would make sense to run it in a batch job. Is there a specific problem you're asking about?
Back to top
View user's profile Send private message
kumarramky

New User


Joined: 04 Aug 2006
Posts: 5

PostPosted: Sat Nov 25, 2006 11:55 am
Reply with quote

Hi Superk
The file (mainframe dataset) is in TAPE. i.e the reason I am asking about this specifically.
Please let me know the batch process of FTP also?

Thanks.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Sat Nov 25, 2006 1:01 pm
Reply with quote

Quote:
The file (mainframe dataset) is in TAPE. i.e the reason I am asking about this specifically.

Then copy to Disk... whats the problem ?
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sat Mar 01, 2008 6:08 am
Reply with quote

Some sites will allow FTP from a tape and some will not. JUst copy the file to disk if you have to.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Mar 01, 2008 9:34 am
Reply with quote

FTP Tape is possible but will take more time since reading tape is time consuming than from dasd.
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
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top