Detail record sorting



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Re: Detail record sorting

Postby enrico-sorichetti » Fri Feb 17, 2012 4:54 pm

Nik!
to start with You have both an OPTION COPY and a SORT card
get rid of one of them.
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Detail record sorting

Postby Nik22Dec » Fri Feb 17, 2012 5:10 pm

enrico-sorichetti wrote:Nik!
to start with You have both an OPTION COPY and a SORT card
get rid of one of them.

Enrico,

Thanks so much for your reply. I removed the OPTION COPY & replaced it with OPTION DYNALLOC & the sort performed as expected by the TS.

If I do not put at least one of the OPTION commands, the job abends with U0189. I am wondering why, since, DYNALLOC & COPY perform two different functions & IMHO are definitely not interchangeable. I am trying to understand why is it mandatory to put at least one OPTION command in the card at my site.

Surprisingly, if you look at the manual at the location ftp://ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf page no. - 47, a similar SORT job runs without any OPTION statement.
Thanks,
Nik
User avatar
Nik22Dec
 
Posts: 68
Joined: Mon Dec 26, 2011 6:38 pm
Has thanked: 2 times
Been thanked: 0 time

Re: Detail record sorting

Postby enrico-sorichetti » Fri Feb 17, 2012 5:16 pm

in this case better ask Your support, never seen an OPTION statement mandatory
also ... it is not the OPTION card that conflicts wit the SORT card ...
it is the COPY parameter that is <wrong>, and <sort> tells You to take a decision COPY or SORT ? :D
for example OPTION EQUALS is accepted
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Detail record sorting

Postby Frank Yaeger » Sat Feb 18, 2012 12:24 am

Purva,

Kolusu showed you how to do what you want in the DFSORT Forum. Please post future DFSORT questions there.

Nik22dec,

U0189 corresponds to ICE189A. Here's the details for ICE189A:

http://publibz.boulder.ibm.com/cgi-bin/ ... 1744&CASE=

I would need to see the complete JES log including all messages you received for the job that got the U0189 in order to tell you why you're getting that message.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Detail record sorting

Postby Nik22Dec » Mon Feb 20, 2012 5:57 pm

Frank Yaeger wrote:Nik22dec,

U0189 corresponds to ICE189A. Here's the details for ICE189A:

http://publibz.boulder.ibm.com/cgi-bin/ ... 1744&CASE=" onclick="window.open(this.href);return false;

I would need to see the complete JES log including all messages you received for the job that got the U0189 in order to tell you why you're getting that message.


Hi Frank,

Thanks so much for your reply. I revisited the spool & could see the below given error message.

ICE189A 0 BLOCKSET REQUIRED BUT COULD NOT BE USED - REASON CODE IS 65  
ICE052I 3 END OF DFSORT                                                


I remember we have had a discussion on this in one of the threads before also. Please refer - http://www.ibmmainframeforum.com/dfsort-icetool-icegener/topic586.html But, at that point of time my input file was having more than 10^8 records but, this time it was just 8 records of 10 bytes each. I am wondering as to how much input can be passed to the SORT utility at max without facing this issue. I believe it is the issue in the installation at my site.
Thanks,
Nik
User avatar
Nik22Dec
 
Posts: 68
Joined: Mon Dec 26, 2011 6:38 pm
Has thanked: 2 times
Been thanked: 0 time

Re: Detail record sorting

Postby Frank Yaeger » Tue Feb 21, 2012 12:57 am

The amount of data that can be sorted without any work files varies depending on several factors. I would recommend NEVER running without work files - there's no reason to.

I'd suggest adding the following to your job:

//DFSPARM  DD *
    OPTION DYNALLOC=(SYSDA,5)
/*


This will allow DFSORT to use dynamically allocated work data sets when needed. If you need more work data sets you can raise the 5 to a higher value (up to 255).
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Detail record sorting

Postby Nik22Dec » Tue Feb 21, 2012 6:28 pm

Thanks so much Frank. Now, I understand!!
Thanks,
Nik
User avatar
Nik22Dec
 
Posts: 68
Joined: Mon Dec 26, 2011 6:38 pm
Has thanked: 2 times
Been thanked: 0 time

Previous

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post