Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to import a large text file into mainframe thru FTP?
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Gopalakrishnan V

Active User


Joined: 28 Jun 2010
Posts: 102
Location: chennai

PostPosted: Tue Nov 23, 2010 4:29 pm    Post subject: How to import a large text file into mainframe thru FTP?
Reply with quote

Hi,

I want to import a large text file of having size about 1.5 GB with 300million records into mainframe thru FTP.

Please provide your inputs and suggessions.

Because I got some error messages as follow,


IKT00405I screen erasure caused by error recovery procedure
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Nov 23, 2010 4:35 pm    Post subject: Reply to: How to import a large text file into mainframe thr
Reply with quote

I really do not see how the IKt*** message could be related to FTP processing

talk to Your support about the FTP standards implemented in Your organization
( file sizes and friends )
Back to top
View user's profile Send private message
Rahul Agrawal

New User


Joined: 19 Jul 2010
Posts: 9
Location: Noida

PostPosted: Tue Nov 23, 2010 7:09 pm    Post subject:
Reply with quote

Please refer to the link:
http://www-01.ibm.com/support/docview.wss?uid=isg1OA01536
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Nov 23, 2010 7:35 pm    Post subject: Reply to: How to import a large text file into mainframe thr
Reply with quote

thanks for the effort,
but did You notice that the apar is a few years old (2003 )
and relates to an old ISPF version/release?
Back to top
View user's profile Send private message
Rahul Agrawal

New User


Joined: 19 Jul 2010
Posts: 9
Location: Noida

PostPosted: Tue Nov 23, 2010 7:37 pm    Post subject:
Reply with quote

Ah. I didn't noticed. Nice observation. icon_smile.gif[/quote]
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 23, 2010 10:09 pm    Post subject:
Reply with quote

Hello,

Quote:
I want to import a large text file of having size about 1.5 GB with 300million records into mainframe thru FTP.

Please provide your inputs and suggessions.
We routinely ftp files that are 9-12 gig with no problems. . .

If there is a problem with your environment, suggest you talk with your network management or storage management people to determine what you need to change.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 2:04 pm    Post subject:
Reply with quote

1610612736 (1.5 GB) / 300.000.000 = 5,36870912

Now i would say thats a very strange record size.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7905
Location: Bellevue, IA

PostPosted: Wed Nov 24, 2010 4:29 pm    Post subject:
Reply with quote

There may be network or site restrictions on the transfer, but there is no reason that an FTP of 1.5 GB would fail due to TCP/IP or FTP. We FTP larger files every day in production so I know there's no problem due to the size of the file transfer.
Back to top
View user's profile Send private message
Gopalakrishnan V

Active User


Joined: 28 Jun 2010
Posts: 102
Location: chennai

PostPosted: Wed Nov 24, 2010 4:43 pm    Post subject:
Reply with quote

Hi,

I was done FTP successfully with 1.5 lac records in mainframe . But If i give more records ie 300million records it got FTP as follow,

Code:


D  10011200303-00020+00000-00020+00000102220101428         
.D  10011200323-00051+00000-00051+00000102220101428         
 .D  10011200337+00028+00000+00028+00000102220101428       
  .D  10011200360+00054+00003+00054+00000102220101428       
   .D  10011200384+00029+00000+00029+00000102220101428     
    .D  10011200394-00018+00000-00018+00000102220101428     
     .D  10011200395-00016+00000-00016+00000102220101428   
      .D  10011200407-00019+00000-00019+00000102220101428   
       .D  10011200473+00013+00000+00013+00000102220101428 
        .D  10011200493+00150+00005+00150+00000102220101428
         .D  10011200494+00000+00000+00000+00000102220101428
          .D  10011200495-00050+00000-00050+0000010222010142
8          .D  10011200496+00014+00000+00014+000001022201014
28          .D  10011200497-00016+00000-00016+00000102220101
428          .D  10011200500-00052+00000-00052+0000010222010
1428          .D  10011200506-00018+00000-00018+000001022201
01428          .D  10011200510-00019+00000-00019+00000102220
101428          .D  10011200518-00019+00000-00019+0000010222
0101428          .D  10011200519-00016+00000-00016+000001022
20101428          .D  10011200520+00070+00000+00070+00000102
220101428          .D  10011200521-00019+00000-00019+0000010
2220101428          .D  10011200522-00016+00000-00016+000001
02220101428          .D  10011200524-00018+00000-00018+00000
102220101428          .D  10011200550-00019+00000-00019+0000
0102220101428          .D  10011200567-00019+00000-00019+000
00102220101428          .D  10011200579-00018+00000-00018+00
000102220101428          .D  10011200586+00148+00005+00148+0
0000102220101428          .D  10011200587-00019+00000-00019+
00000102220101428          .D  10011200588-00050+00000-00050
+00000102220101428          .D  10011200589-00019+00000-0001
9+00000102220101428          .D  10011200590-00051+00000-000
51+00000102220101428          .D  10011200592+00013+00001+00





Please Give your inputs.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7905
Location: Bellevue, IA

PostPosted: Wed Nov 24, 2010 4:51 pm    Post subject:
Reply with quote

Is your FTP going to a previously allocated data set? Many times this type of stair stepping occurs when the LRECL of the dataset is not the same as the record length of the data being transferred.
Back to top
View user's profile Send private message
Gopalakrishnan V

Active User


Joined: 28 Jun 2010
Posts: 102
Location: chennai

PostPosted: Wed Nov 24, 2010 5:04 pm    Post subject:
Reply with quote

No it is not preallocated. But i mentioned in FTP options , LRECL as 60.

For 1 lac it processed correctly. Then also same set up i used.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 6:20 pm    Post subject:
Reply with quote

Is this a double post ?

http://ibmmainframes.com/viewtopic.php?t=52261

What the hell is a "lac" ?

Are we talking sanskrit now?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Nov 24, 2010 6:29 pm    Post subject:
Reply with quote

Peter, you're showing your "lac" of knowledge there icon_lol.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 6:52 pm    Post subject:
Reply with quote

expat wrote:
Peter, you're showing your "lac" of knowledge there icon_lol.gif


Expat, thats a nice one. The way you say it im shooting myself in the foot . icon_lol.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Nov 24, 2010 8:01 pm    Post subject:
Reply with quote

Peter, just so long as my foot is safe ..............................
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 8:04 pm    Post subject:
Reply with quote

expat wrote:
Peter, just so long as my foot is safe ..............................


I would never hurt you. icon_biggrin.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 24, 2010 8:27 pm    Post subject: Reply to: How to import a large text file into mainframe thr
Reply with quote

Quote:
Peter, just so long as my foot is safe ..............................

Better the foot than somewhat higher. . . icon_wink.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Nov 24, 2010 9:21 pm    Post subject:
Reply with quote

PeterHolland wrote:
Is this a double post ?

http://ibmmainframes.com/viewtopic.php?t=52261

What the hell is a "lac" ?

Are we talking sanskrit now?

Nope, Pali.

(A "lac" (also romanized as "lakh") is 100,000. Some of the people posting in these fora will also use "crore", 10,000,000, which is derived from Sanskrit.)
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 10:52 pm    Post subject:
Reply with quote

Akatsukami wrote:
PeterHolland wrote:
Is this a double post ?

http://ibmmainframes.com/viewtopic.php?t=52261

What the hell is a "lac" ?

Are we talking sanskrit now?

Nope, Pali.

(A "lac" (also romanized as "lakh") is 100,000. Some of the people posting in these fora will also use "crore", 10,000,000, which is derived from Sanskrit.)


Thank you so much for explaining, what i want to say is talk english how the hell is anyone to understand if i answer in my own language. Except of course some expats from Europe.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 24, 2010 10:55 pm    Post subject: Re: Reply to: How to import a large text file into mainframe
Reply with quote

dick scherrer wrote:
Quote:
Peter, just so long as my foot is safe ..............................

Better the foot than somewhat higher. . . icon_wink.gif


Dick, im so sorry to tell you im one of those guys having 3 legs. icon_redface.gif
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
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us