MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

What’s involved to convert from SYSNCSORT to DFSORT?

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Mon Sep 25, 2006 1:31 pm    Post subject: What Reply with quote

Our shop is considering switching sort products. We do mostly standard Include/Omit selection criteria. What are the "GOTCHAS' between the two? We are running zOS 1.4.
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Mon Sep 25, 2006 4:39 pm    Post subject: Reply with quote

NASCAR9,

Send me your e-mail address offline (yaeger@us.ibm.com) and I'll send you some documents prepared by the DFSORT Team that will answer your question in detail. Please put "DFSORT" somewhere in your Subject line to catch my attention.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Mon Sep 25, 2006 6:45 pm    Post subject: Reply with quote

Thanks Frank, my email is on the way.
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Tue Sep 26, 2006 10:37 am    Post subject: Reply with quote

If you are using FOCUS and will be processing large input files with any kind or sort, then you should investigate the DFSPARM DD statement and the FILESZ=Ennnn parameter to allow the sort space to be preallocated correctly. We had a number of problems with this.
Back to top
View user's profile Send private message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Tue Sep 26, 2006 11:12 am    Post subject: Reply with quote

Bithead are you refering to FOCUS DB? If so, we have DB2 and IMS running on the mainframe.

How about OUTREC statments?


Code:

OUTREC FIELDS=(01,05,PD,EDIT=(TTTTTTTTT),         
              C'|',010,20,C'|',195,02,           
              C'|',007,02,C'|',589,02,C'|',587,02,
              C'|',591,02,C'|',219,01,C'|',220,01,
              C'|',221,01,                       
              C'|',37,04,C'-',41,02,             
              C'|',243,01,C'|',244,02,C'-',246,02,
              C'|',248,02,C'-',250,02,           
              C'|',197,02,C'-',199,02,           
              C'|',201,02,C'-',203,02,           
              C'|',206,02,C'-',208,02,           
              C'|',136,1)           
             

_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Tue Sep 26, 2006 12:07 pm    Post subject: Reply with quote

NASCAR9,

I've sent you the documents. Please read through them and feel free to send me an e-mail offline if you have any specific questions not answered by the docs. Note that all of the DFSORT books are available online from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html

That OUTREC statement works fine with DFSORT.

I don't know anything about how FOCUS uses DFSORT, but if it passes all of the records to DFSORT through an E15 exit and does NOT tell DFSORT the filesize (not a good design), then DFSORT will use the DYNSPC installation value to determine how much space to allocate. If the DYNSPC installation value is insufficient, you can increase it. It wouldn't be necessary to pass FILSZ (FILSZ is the correct parameter name, not FILESZ) for each FOCUS job, although you can if you want to.

Note that, in general, FILSZ isn't needed because DFSORT can determine the filesize automatically in all but a few cases (e.g. when all of the records are passed to DFSORT via an E15). And in those cases, DYNSPC will usually take care of it. So don't assume that there will be a problem.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group