Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7314

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 Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us