IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Automate a test job that checks potential SB37


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Vishal Trehan

New User


Joined: 21 Apr 2008
Posts: 5
Location: Mysore

PostPosted: Fri May 30, 2008 2:26 pm
Reply with quote

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
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 459
Location: Belgium

PostPosted: Fri May 30, 2008 2:39 pm
Reply with quote

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
View user's profile Send private message
Vishal Trehan

New User


Joined: 21 Apr 2008
Posts: 5
Location: Mysore

PostPosted: Fri May 30, 2008 2:50 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri May 30, 2008 3:19 pm
Reply with quote

I believe that SMF type 15 records will have the space and extent usage information.
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland

PostPosted: Fri May 30, 2008 4:02 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri May 30, 2008 4:06 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Zunit Test case editor error Testing & Performance 4
No new posts Copying GDG version(all/few) from pro... CLIST & REXX 13
No new posts REXX Test under Mask??? CLIST & REXX 3
No new posts Dynamic condition checks COBOL Programming 5
No new posts Assembler test under mask question PL/I & Assembler 5
Search our Forums:

Back to Top