MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Gather list of datasets and space used

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
aashish.paul
Beginner


Joined: 17 Apr 2008
Posts: 12
Topics: 3

PostPosted: Thu Mar 12, 2009 3:15 pm    Post subject: Gather list of datasets and space used Reply with quote

I would like to get a list of all the datset with a HLQ like ABCD.* with the amount of space it is using.


Output could be like

ABCD.EFGH1 123 tracks
ABCD.EFGH2 234 tracks
.
.
.
ABCD.WERT9 23 tracks


I was pretty sure that this must have been posted earlier but I couldnt find it. Any help would be appreciated. Thanks.
Back to top
View user's profile Send private message
taltyman
JCL Forum Moderator
JCL Forum Moderator


Joined: 02 Dec 2002
Posts: 310
Topics: 8
Location: Texas

PostPosted: Fri Mar 13, 2009 8:30 am    Post subject: Reply with quote

If it's just a one time shot then do an ISPF 3.4 with your dsn mask and then use the SAVE command to create a dataset with the information you need. From 3.4 the SAVE JUNK command would create a dataset named userid.JUNK.DATASETS
Back to top
View user's profile Send private message
computer
Beginner


Joined: 12 Jun 2007
Posts: 64
Topics: 17
Location: Hyderabad

PostPosted: Fri Mar 13, 2009 10:05 am    Post subject: Reply with quote

Hi,

REXX will also work....

JUST Issue 'LISTC DSNAME' inside the rexx program, then catch the listing with OUTTRAP function.....

Then go for filteration of desired desired things.
Back to top
View user's profile Send private message
aashish.paul
Beginner


Joined: 17 Apr 2008
Posts: 12
Topics: 3

PostPosted: Fri Mar 13, 2009 11:15 am    Post subject: Reply with quote

Thank you tallyman. Your idea works perfectly.

I never thought of that but was looking for the JCL way from the word go. bonk
Back to top
View user's profile Send private message
aashish.paul
Beginner


Joined: 17 Apr 2008
Posts: 12
Topics: 3

PostPosted: Fri Mar 13, 2009 11:42 am    Post subject: Reply with quote

Hi tallyman I am missing migrated datasets information.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Fri Mar 13, 2009 1:00 pm    Post subject: Reply with quote

aashish.paul,

Well if your intention is to get the migrated dataset info also then submit this job which would issue a hrecall for all the datasets. if you have many datasets that are migrated this job might run for a long time.


Code:

//STEP0100 EXEC PGM=IKJEFT01   
//SYSTSPRT DD SYSOUT=*         
//SYSTSIN  DD *               
  LISTDS 'ABCD' LEVEL
/*
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Terry_Heinze
Supermod


Joined: 31 May 2004
Posts: 391
Topics: 4
Location: Richfield, MN, USA

PostPosted: Fri Mar 13, 2009 6:00 pm    Post subject: Reply with quote

To help with summing the tracks used, open a spread sheet, select and copy from your ISPF screen the column of tracks, then paste into a spread sheet cell. I've used this manual method many times for summing a long column of numbers.
_________________
....Terry
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Fri Mar 13, 2009 6:43 pm    Post subject: Reply with quote

Terry_Heinze wrote:
To help with summing the tracks used, open a spread sheet, select and copy from your ISPF screen the column of tracks, then paste into a spread sheet cell. I've used this manual method many times for summing a long column of numbers.


Terry_heinze,

Why would you do that manually? Isn't it tedious if you have large number of datasets? I guess you aware of UFF formats for sort which would just extract number from any format which you can use for summing
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Terry_Heinze
Supermod


Joined: 31 May 2004
Posts: 391
Topics: 4
Location: Richfield, MN, USA

PostPosted: Fri Mar 13, 2009 8:02 pm    Post subject: Reply with quote

The total number of data sets (or other items containing these numbers) was no more than 2 or 3 screens and they were for an ad hoc request for total number of tracks. Had the numbers that needed totaling been more than that, or had the request been on a regular basis, I would've researched SORT to accomplish the task or maybe used Easytrieve. Even a COBOL program would've worked.
_________________
....Terry
Back to top
View user's profile Send private message Send e-mail
aashish.paul
Beginner


Joined: 17 Apr 2008
Posts: 12
Topics: 3

PostPosted: Mon Mar 23, 2009 2:23 pm    Post subject: Reply with quote

Thanks Terry, Kolusu I have about 50K datasets for which I need to get the space utilization. Recalling that many datasets was not a reasonable solution. When I contacted the system administer he was able to give me the information without recalling the datasets.
Apparently they already have a JOB outputting the space utilization of all datasets on the system. I would like to a peek at this JOB but I dont think they would allow that. All I had to do was copy the datasets I want to another dataset and import to excel. Thanks again.
Back to top
View user's profile Send private message
taltyman
JCL Forum Moderator
JCL Forum Moderator


Joined: 02 Dec 2002
Posts: 310
Topics: 8
Location: Texas

PostPosted: Tue Mar 24, 2009 8:02 am    Post subject: Reply with quote

They are probably using DCOLLECT to get that information. http://publib.boulder.ibm.com/infocenter/zos/v1r9/index.jsp?topic=/com.ibm.zos.r9.idai200/dcoll.htm
Back to top
View user's profile Send private message
BobGilbert
Beginner


Joined: 12 Sep 2006
Posts: 24
Topics: 10

PostPosted: Thu May 07, 2009 11:58 am    Post subject: Reply with quote

You can use filemanager...for catlogue. I created a proc and pass in &app. This will show Kilobytes allocated and used..
***************************
$$FILEM SCS ,
$$FILEM DSNAME="&APP*.**",
$$FILEM INCLUDE=NO,
$$FILEM ENTRIES=ALL,
$$FILEM SORTBY=NAME


For VTOC you can use filemanager as well.... I created a proc and pass in &app. Only non migrated show up in this list. This will show last referance date as well

$$FILEM DVT ,
$$FILEM VOLSER=*,
$$FILEM DSNAME="&APP*.**",
$$FILEM DATEFORM=YYDDD,
$$FILEM DSNREPEAT=YES,
$$FILEM SUMMARY=NO,
$$FILEM COMBINE=NO,
$$FILEM SORTDSNBY=NAME,
$$FILEM SORTVOLBY=VOLSER

And for migrated you can use HLIST commands...

HLIST LEVEL('RMS') BOTH ODS(RMS.ALL)

Using all three you can get a nice inventory of what is in the system. Use REXX, SAS or whatever tool you like to merge all into one. I am using this to get pictures of applications...

Bob Gilbert
Back to top
View user's profile Send private message Send e-mail
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Fri May 08, 2009 5:37 am    Post subject: Reply with quote

Or ISMF if it is made generally available to users / developers
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group