IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DFSORT sortwork datasets


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Dhanya Sreevalsam

New User


Joined: 13 Mar 2012
Posts: 7
Location: india

PostPosted: Tue Mar 13, 2012 10:50 am
Reply with quote

hi iam writing a sort job to replace phoneorders with spaces.please find the sort card below.

Code:

   OPTION COPY                                       
   OUTREC IFTHEN=(WHEN=(865,11,CH,EQ,C'PHONEORDERS',
     AND,910,19,CH,EQ,C'CS.MANDS.AMAZON.COM'),         
              BUILD=(1:1,864,91X,956:956,443))   


dfsort version is Z/OS DFSORT V1R10.

lrecl of input file is 1339 and contains about one million records.


could you please guide me whether i should use sortwork datasets for the above since am going to implement this job in production?
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Tue Mar 13, 2012 11:33 am
Reply with quote

Hi,

you are copying not sorting hence no SORTWK datasets are needed.


Gerry
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Mar 13, 2012 12:39 pm
Reply with quote

You are going to test it before it goes into production? This will reveal your answer, won't it?
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Mar 13, 2012 9:53 pm
Reply with quote

Dhanya Sreevalsam,

You are just copying the input to output while editing the contents for a few records, so there is NO need for sort work datasets. However I suggest you use OVERLAY instead of BUILD as you just need to space out the contents at position 865 for a length of 91 bytes.

Code:

  OPTION COPY                                               
  OUTREC IFTHEN=(WHEN=(865,11,CH,EQ,C'PHONEORDERS',AND,     
                       910,19,CH,EQ,C'CS.MANDS.AMAZON.COM'),
        OVERLAY=(865:91X))                                 
Back to top
View user's profile Send private message
Dhanya Sreevalsam

New User


Joined: 13 Mar 2012
Posts: 7
Location: india

PostPosted: Wed Mar 14, 2012 10:02 am
Reply with quote

many thanks for all your quick responses
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Mar 14, 2012 8:51 pm
Reply with quote

COPY operation or not - is not DYNALLOC option is "usually" default these days?

OP has not mentioned about it, so I'll take the benefit of doubt and say just don't code SORTWORK files - is not it true, keeping the first statement of mine in mind?
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA

PostPosted: Wed Mar 14, 2012 10:26 pm
Reply with quote

Quote:
COPY operation or not - is not DYNALLOC option is "usually" default these days

Not really. It depends on what system admins has DYNAUTO defaulted to. DYNAUTO=IGNWKDD would do that but that's generally not how it is set. [citation needed]

Most cases, DYNAUTO is set to YES so if someone wants SORTWK they can use it that way or else DYNAMIC ALLOCATION. Atleast that's how we have it our system.

Thanks,
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Wed Mar 14, 2012 11:04 pm
Reply with quote

In general, we recommend not specifying SORTWKdd DD statements so DFSORT can use dynamically allocated work data sets.

However, if you do specify SORTWKdd DD statements, DFSORT will use them and NOT use dynamically allocated work data sets, unless your site has set DYNAUTO=IGNWKDD as the installation default. With DYNAUTO=IGNWKDD, DFSORT deallocates the SORTWKdd DD data sets and use dynamically allocated work data sets.

And, of course, work data sets are only needed for a sort application, not a copy or merge application.
Back to top
View user's profile Send private message
girishbs13

New User


Joined: 11 Nov 2011
Posts: 24
Location: India

PostPosted: Thu Mar 15, 2012 12:10 pm
Reply with quote

Is there any way to check to what value DYNAUTO is set in my system?
I checked DFSORT spool message and was unable to find it.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA

PostPosted: Thu Mar 15, 2012 6:35 pm
Reply with quote

girishbs13,
Run this job and check OUT.

Code:
//STEP0001 EXEC PGM=ICETOOL   
//TOOLMSG   DD SYSOUT=*       
//DFSMSG    DD SYSOUT=*       
//OUT       DD SYSOUT=*       
//TOOLIN    DD *               
  DEFAULTS LIST(OUT)           
/*                             

Thanks,
Back to top
View user's profile Send private message
girishbs13

New User


Joined: 11 Nov 2011
Posts: 24
Location: India

PostPosted: Fri Mar 16, 2012 2:33 pm
Reply with quote

Thanks sqlcode1
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Mar 16, 2012 4:59 pm
Reply with quote

Thanks - was curious.

Have a good one, icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top