Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to download/FTP the TAPE files into Windows - DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: How to download/FTP the TAPE files into Windows - DB2
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

Moderator Team Head


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

PostPosted: Fri Nov 24, 2006 8:40 am    Post subject: Re: How to download/FTP the TAPE files into Windows - DB2
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    Post subject:
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: 1452
Location: Chicago, IL

PostPosted: Sat Nov 25, 2006 1:01 pm    Post subject: Re: How to download/FTP the TAPE files into Windows - DB2
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    Post subject:
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    Post subject:
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    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 Comparing two sequential files Mohan Kothakota COBOL Programming 14 Mon Apr 16, 2018 6:35 pm
No new posts SORT 3 files,extract specific fields ... Kiransr DFSORT/ICETOOL 13 Fri Mar 23, 2018 10:54 am
No new posts How to build one file from two input ... daniele DFSORT/ICETOOL 5 Tue Feb 27, 2018 6:45 pm
No new posts Tape file issue abdulrafi JCL & VSAM 2 Thu Feb 08, 2018 12:01 pm
No new posts Compare two PS files using ICE TOOL f... SENTHIL MURUGAAN DFSORT/ICETOOL 5 Sun Dec 24, 2017 1:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us