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
 

 

DFSORT sortwork datasets

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: DFSORT sortwork datasets
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: 1703
Location: Australia

PostPosted: Tue Mar 13, 2012 11:33 am    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Tue Mar 13, 2012 12:39 pm    Post subject: Reply to: DFSORT sortwork datasets
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    Post subject:
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    Post subject: Reply to: DFSORT sortwork datasets
Reply with quote

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

Senior Member


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

PostPosted: Wed Mar 14, 2012 8:51 pm    Post subject:
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: 578
Location: USA

PostPosted: Wed Mar 14, 2012 10:26 pm    Post subject:
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 Moderator


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

PostPosted: Wed Mar 14, 2012 11:04 pm    Post subject:
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    Post subject:
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: 578
Location: USA

PostPosted: Thu Mar 15, 2012 6:35 pm    Post subject:
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    Post subject:
Reply with quote

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

Senior Member


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

PostPosted: Fri Mar 16, 2012 4:59 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am


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