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: 7904
Location: Bellevue, IA

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: 1609
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: 7223

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: 2422
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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