View previous topic :: View next topic
|
Author |
Message |
Gopalakrishnan V
Active User
Joined: 28 Jun 2010 Posts: 102 Location: chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Rahul Agrawal
New User
Joined: 19 Jul 2010 Posts: 9 Location: Noida
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Rahul Agrawal
New User
Joined: 19 Jul 2010 Posts: 9 Location: Noida
|
|
|
|
Ah. I didn't noticed. Nice observation. [/quote] |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
1610612736 (1.5 GB) / 300.000.000 = 5,36870912
Now i would say thats a very strange record size. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Gopalakrishnan V
Active User
Joined: 28 Jun 2010 Posts: 102 Location: chennai
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Gopalakrishnan V
Active User
Joined: 28 Jun 2010 Posts: 102 Location: chennai
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Peter, you're showing your "lac" of knowledge there |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
expat wrote: |
Peter, you're showing your "lac" of knowledge there |
Expat, thats a nice one. The way you say it im shooting myself in the foot . |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Peter, just so long as my foot is safe .............................. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
expat wrote: |
Peter, just so long as my foot is safe .............................. |
I would never hurt you. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Quote: |
Peter, just so long as my foot is safe .............................. |
Better the foot than somewhat higher. . . |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Akatsukami wrote: |
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
dick scherrer wrote: |
Quote: |
Peter, just so long as my foot is safe .............................. |
Better the foot than somewhat higher. . . |
Dick, im so sorry to tell you im one of those guys having 3 legs. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
PeterHolland wrote: |
Akatsukami wrote: |
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. |
"Lakh" and "crore" are English. Indian English, to be sure, but as has been said, English doesn't borrow words from other languages, it mugs them, drags them into dark alleys and rifles their pockets for vocabulary |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Peter,
Quote: |
Dick, im so sorry to tell you im one of those guys having 3 legs. |
How did you lose the 4th leg . . .
d |
|
Back to top |
|
|
|