View previous topic :: View next topic |
Author |
Message |
aashish.paul Beginner
Joined: 17 Apr 2008 Posts: 12 Topics: 3
|
Posted: Thu Mar 12, 2009 3:15 pm Post subject: Gather list of datasets and space used |
|
|
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 |
|
 |
taltyman JCL Forum Moderator

Joined: 02 Dec 2002 Posts: 310 Topics: 8 Location: Texas
|
Posted: Fri Mar 13, 2009 8:30 am Post subject: |
|
|
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 |
|
 |
computer Beginner
Joined: 12 Jun 2007 Posts: 64 Topics: 17 Location: Hyderabad
|
Posted: Fri Mar 13, 2009 10:05 am Post subject: |
|
|
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 |
|
 |
aashish.paul Beginner
Joined: 17 Apr 2008 Posts: 12 Topics: 3
|
Posted: Fri Mar 13, 2009 11:15 am Post subject: |
|
|
Thank you tallyman. Your idea works perfectly.
I never thought of that but was looking for the JCL way from the word go.  |
|
Back to top |
|
 |
aashish.paul Beginner
Joined: 17 Apr 2008 Posts: 12 Topics: 3
|
Posted: Fri Mar 13, 2009 11:42 am Post subject: |
|
|
Hi tallyman I am missing migrated datasets information. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Fri Mar 13, 2009 1:00 pm Post subject: |
|
|
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 |
|
 |
Terry_Heinze Supermod
Joined: 31 May 2004 Posts: 391 Topics: 4 Location: Richfield, MN, USA
|
Posted: Fri Mar 13, 2009 6:00 pm Post subject: |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Fri Mar 13, 2009 6:43 pm Post subject: |
|
|
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 |
|
 |
Terry_Heinze Supermod
Joined: 31 May 2004 Posts: 391 Topics: 4 Location: Richfield, MN, USA
|
Posted: Fri Mar 13, 2009 8:02 pm Post subject: |
|
|
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 |
|
 |
aashish.paul Beginner
Joined: 17 Apr 2008 Posts: 12 Topics: 3
|
Posted: Mon Mar 23, 2009 2:23 pm Post subject: |
|
|
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 |
|
 |
taltyman JCL Forum Moderator

Joined: 02 Dec 2002 Posts: 310 Topics: 8 Location: Texas
|
|
Back to top |
|
 |
BobGilbert Beginner
Joined: 12 Sep 2006 Posts: 24 Topics: 10
|
Posted: Thu May 07, 2009 11:58 am Post subject: |
|
|
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 |
|
 |
expat Intermediate

Joined: 01 Mar 2007 Posts: 475 Topics: 9 Location: Welsh Wales
|
Posted: Fri May 08, 2009 5:37 am Post subject: |
|
|
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 |
|
 |
|
|