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
 

 

Predicting jobs which are about to reach the Sort capacity

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
kpanchabhai85

New User


Joined: 30 Jun 2016
Posts: 1
Location: USA

PostPosted: Thu Jun 30, 2016 7:51 pm    Post subject: Predicting jobs which are about to reach the Sort capacity
Reply with quote

Hi Everyone ,

We work in a org where multiple MF applicaitons are active. Several jobs go down with the U0016 abend code for Exceeding sort capacity.

As a automation unit we have been asked to device a preventive tool , which will help in identifying the jobs which are about the reach the sort capacity coded in the JCL.

Due to differnet applications in MF , coding sort parameters have been different like some may go with DYNALLOC & some would go ahead and code SRTWKnn.

Approach we are thinking of is as below :

1. Calculate the count of records in each input file in verious sort steps.
2. Include a program which will calcualte the sort capacity needed for processing the count of records from step#1.
3. Pass on the cylinders required in SYSIN in DYNALLOC method.

with this we will always have enough sort capacity required for any increase or decrease of the record counts in different jobs.

Questions :
1. Will this approach work well ? any flip side to this approach ?
2. Is there any other easier approach which can be implmented across multiple different MF applicaitons ?

Thanks a lot in advance for your help !!
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8132
Location: East Dubuque, Illinois, USA

PostPosted: Thu Jun 30, 2016 8:28 pm    Post subject:
Reply with quote

First, you didn't mention if you're using SYNCSORT, DFSORT, CA-SORT or whatever -- suggestions vary somewhat for different sort packages since they don't all have the exact same parameters.

Second, if some of your sorts use tape input, how will you calculate the number of records other than reading the data set -- which, basically, means you're having to duplicate the reads the sort program will do?

Third, wouldn't it be quicker and easier to just make one pass through all the sorts and remove the SORTWKnn and all the other sort-related DD statements (for DFSORT that would include SW01WKnn, DATAWKnn, DA01WKnn, STATWKnn, and ST01WKnn,UTPRINnn,DTPRINn but not SORTDIAG and UTPRINT) so dynamic allocation can be used? Set a moderate primary and large secondary for the dynamic allocation and ensure that there is plenty of disk space and that sort can allocate plenty of dynamic work files.

Fourth, how many sorts does your site have that ABEND with SORT CAPACITY EXCEEDED each day/week/month? If you have 1 sort a month ABEND, it looks like a great deal of effort is being spent to correct a minor problem. Similarly, if only one application regularly gets the error message, perhaps you should focus on that one application instead of doing something site-wide.

This really sounds more like a busywork project to pad billing hours than something that any production mainframe environment would need.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1742
Location: NY,USA

PostPosted: Thu Jun 30, 2016 9:05 pm    Post subject:
Reply with quote

Welcome!!
You will have to work this out with System Programmer and may get a better solution and I would suggest you to take a look Specifying EXEC/DFSPARM PARM options and Using work space at the least ,before you make a discussion and it is not necessary to scan all the jobs across multiple MF projects as this will itself become a BIG Project, so concentrate only on those apps which you think can be processing huge volumes of data and potential candidates for failures.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Thu Jun 30, 2016 9:25 pm    Post subject: Reply to: Predicting jobs which are about to reach the Sort capacity
Reply with quote

If you are going to be automating things, you really need to be aware of the charging structures for resources at your site. Reading the data to see how much data there is is a waste of resources and usually the resources are paid for.

You should look out in your documentation for words like Installation, Tuning and Configuration and read all the related information.

DFSORT for instance makes an estimate of space required when using dynamic allocation for workspace. There are some diagnostic messages (which you could extract from "spool" output) which can highlight jobsteps with actual issues.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2436
Location: Netherlands, Amstelveen

PostPosted: Thu Jun 30, 2016 9:29 pm    Post subject:
Reply with quote

Maybe this could help :

http://ibmmainframes.com/about39616.html
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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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