View previous topic :: View next topic
|
Author |
Message |
Vishal Trehan
New User
Joined: 21 Apr 2008 Posts: 5 Location: Mysore
|
|
|
|
hi all
i need to automate ( write a JCL ) so as to check for potential space allocation problems( SB37) and send the list of files to some mail id.
i have some idea about how to proceed about the mail part but clueless about checking the potential space allocation problem.
The information available to me:
1. The set of files OR
2. Files used in some JCL OR
3. Qualifier for the file. SO i need to check for all the files with that qualifier.
Any kind of help or suggestion would be appreciated. |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
So you are able to predict the trends of business, with some special events having for effect to increase the amount of records? Monthly, annual processes, peak movements on security, on account or any other Id ? |
|
Back to top |
|
|
Vishal Trehan
New User
Joined: 21 Apr 2008 Posts: 5 Location: Mysore
|
|
|
|
not exactly.
this information will help us in knowing which files might have space allocation problem. So that they can be avoided. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
I believe that SMF type 15 records will have the space and extent usage information. |
|
Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
|
|
|
|
It'd probably be simpler to write some REXX using LISTDSI to get at the current information based on (e.g.)
Code: |
/** REXX **/
rc1 = LISTDSI("'MQT.GARRY.SOURCE'")
say '------------'
say 'Units ' sysunits
say 'Alloc ' sysalloc
say 'Primary ' sysprimary
say 'Secondary ' sysseconds
say 'Extents ' sysextents
say '------------'
return
EXIT |
If there's no secondary and sysalloc is nearing sysprimary, or if sysextents is nearing maximum, there's a potential issue.
For VSAM files, use LISTCAT information.
Regards,
Garry. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
In fact, DCOLLECT will have everything that you will want and if you look through some of the stuff that Frank has posted in the SORT forum I'm sure that he gave a sample code for exactly what you want to achieve |
|
Back to top |
|
|
|