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 FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm

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