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
 

 

Automate a test job that checks potential SB37

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Automate a test job that checks potential SB37
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: 456
Location: Belgium

PostPosted: Fri May 30, 2008 2:39 pm    Post subject:
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    Post subject: Reply to: Automate a test job that checks potential SB37
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: 8593
Location: Back in jolly old England

PostPosted: Fri May 30, 2008 3:19 pm    Post subject:
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

Active Member


Joined: 08 May 2006
Posts: 994
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Fri May 30, 2008 4:02 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Fri May 30, 2008 4:06 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Full health checks of IMS databases ashek15 IMS DB/DC 1 Sat Apr 01, 2017 8:34 am
No new posts COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm
This topic is locked: you cannot edit posts or make replies. How to supply called sub-program from... dchristensen JCL & VSAM 25 Wed Sep 14, 2016 11:36 pm
No new posts Two different PDS production and test... Mani453 CLIST & REXX 6 Fri Nov 20, 2015 2:25 pm
No new posts Weird test results when Xpediter is t... Crunch Compuware & Other Tools 6 Tue Oct 06, 2015 7:48 pm


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