Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Best way to sort 50 Milions of record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
MGIndaco

Moderator


Joined: 10 Mar 2005
Posts: 478
Location: Milan, Italy

PostPosted: Tue Sep 13, 2005 11:53 pm    Post subject: Best way to sort 50 Milions of record
Reply with quote

Hi to all.
From few month I'm sorting a file with almost 50 milions of record of a file* that has this feature:
Code:
LRECL=416,RECFM=FB
(and a key of sort of 19 char)
* = is not only one file but are 3 file concatenated

At the moment the sort run, with many SORTWK, in 1 hour(I know that this depend on the hardware of MF) but to reduce this time I'm looking for another solution.

I tested ICETOOL increasing the DYNALLOC option and I've specified the
Code:
OPTION DYNALLOC=(SYSDA,10),FILSZ=E50000000

but the time is not changed.


Thanks in advance both for comment and solution.
Back to top
View user's profile Send private message
References
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4621
Location: San Jose, CA

PostPosted: Wed Sep 14, 2005 1:47 am    Post subject:
Reply with quote

I can't really comment on your question without seeing your JCL, control statements, and the DFSORT diagnostic messages which requires adding the following to your job and rerunning it:

//SORTDIAG DD DUMMY

Assuming you're using DFSORT, if you want to send me all that offline (yaeger@us.ibm.com), I'll take a look, but I actually won't have any internet access after today for about 10 days so I won't be able to answer my mail or post here for a while. If you do e-mail me, please put "DFSORT" somewhere in your Subject line to catch my attention.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1