Discussion:
JCL to get a report of large datasets
(too old to reply)
Ron Thomas
2017-08-01 20:54:13 UTC
Permalink
Raw Message
Hi . Is there using utility job where i can use it pull all datasets that occupy huge space . Let me know how i can go ahead and do it .?

Regards
Ron T

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Lizette Koehler
2017-08-01 20:56:30 UTC
Permalink
Raw Message
If you have any CA products, CA1, CA JCLCHECK, CA TLMS, etc.... You can download and install CA GMI (Graphically Manager Interface)

It will give you everything you want an more.

Other wise the DFSMS function ISMF will do what you want as well.

Lizette

-----Original Message-----
Sent: Aug 1, 2017 1:55 PM
Subject: JCL to get a report of large datasets
Hi . Is there using utility job where i can use it pull all datasets that occupy huge space . Let me know how i can go ahead and do it .?
Regards
Ron T
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
retired mainframer
2017-08-01 21:16:17 UTC
Permalink
Raw Message
You can use DSS in test mode to list the names of datasets using the BY operand to filter of FSIZE.
Post by Lizette Koehler
-----Original Message-----
Behalf Of Ron Thomas
Sent: Tuesday, August 01, 2017 1:55 PM
Subject: JCL to get a report of large datasets
Hi . Is there using utility job where i can use it pull all datasets that occupy huge space .
Let me know how i can go ahead and do it .?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Ron Thomas
2017-08-01 21:54:43 UTC
Permalink
Raw Message
Can i get a sample job or so to pull the information based on the high-level qualifier of dataset ? Thanks!

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Sri h Kolusu
2017-08-01 22:43:32 UTC
Permalink
Raw Message
Keeping it simple solution

1. OPTION 3.4
2. HLQ.* ( Make sure you have / Include Additional Qualifiers)
3. Type SAVE <any name> and hit Enter
4. The list will be saved as HLQ.anyname
5. View/Edit list dataset HLQ.anyname
6. Issue the command SORT 75 87 D
7. You got the DSNAME and the tracks.

Note : This method is NOT applicable to migrated datasets.

You can run HLIST command on migrated datasets on LEVEL and get the
listing into a dataset.

Thanks,
Kolusu
Date: 08/01/2017 02:56 PM
Subject: Re: JCL to get a report of large datasets
Can i get a sample job or so to pull the information based on the
high-level qualifier of dataset ? Thanks!
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Lizette Koehler
2017-08-01 23:03:41 UTC
Permalink
Raw Message
I would write an REXX.

You could then specify the HLQ. And then use LISTC lvl("hlq") all

Run through the output finding the full DSN. Then use the LISTDSI to see the size of the file.

If it matches your requirements, you can SAY the data.

This can be in a Batch TSO Step.

Or go to the CBTTAPE.ORG and see if there is a freeware function you can use.


Lizette



-----Original Message-----
Sent: Aug 1, 2017 3:44 PM
Subject: Re: JCL to get a report of large datasets
Keeping it simple solution
1. OPTION 3.4
2. HLQ.* ( Make sure you have / Include Additional Qualifiers)
3. Type SAVE <any name> and hit Enter
4. The list will be saved as HLQ.anyname
5. View/Edit list dataset HLQ.anyname
6. Issue the command SORT 75 87 D
7. You got the DSNAME and the tracks.
Note : This method is NOT applicable to migrated datasets.
You can run HLIST command on migrated datasets on LEVEL and get the
listing into a dataset.
Thanks,
Kolusu
Date: 08/01/2017 02:56 PM
Subject: Re: JCL to get a report of large datasets
Can i get a sample job or so to pull the information based on the
high-level qualifier of dataset ? Thanks!
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Lizette Koehler
2017-08-01 23:11:54 UTC
Permalink
Raw Message
A good suggestion was using DFDSS

https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.adru000/by.htm

You can filter by FSIZE Number of allocated or used tracks for the entire data set on all the volumes on which it resides (data set size)


Remember to use PARM='TYPRUN=NORUN' to make sure you do not do any actual actions.

You can probably use DUMP or COPY for this process.

Lizette

-----Original Message-----
Sent: Aug 1, 2017 4:04 PM
Subject: Re: JCL to get a report of large datasets
I would write an REXX.
You could then specify the HLQ. And then use LISTC lvl("hlq") all
Run through the output finding the full DSN. Then use the LISTDSI to see the size of the file.
If it matches your requirements, you can SAY the data.
This can be in a Batch TSO Step.
Or go to the CBTTAPE.ORG and see if there is a freeware function you can use.
Lizette
-----Original Message-----
Sent: Aug 1, 2017 3:44 PM
Subject: Re: JCL to get a report of large datasets
Keeping it simple solution
1. OPTION 3.4
2. HLQ.* ( Make sure you have / Include Additional Qualifiers)
3. Type SAVE <any name> and hit Enter
4. The list will be saved as HLQ.anyname
5. View/Edit list dataset HLQ.anyname
6. Issue the command SORT 75 87 D
7. You got the DSNAME and the tracks.
Note : This method is NOT applicable to migrated datasets.
You can run HLIST command on migrated datasets on LEVEL and get the
listing into a dataset.
Thanks,
Kolusu
Date: 08/01/2017 02:56 PM
Subject: Re: JCL to get a report of large datasets
Can i get a sample job or so to pull the information based on the
high-level qualifier of dataset ? Thanks!
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Gibney, Dave
2017-08-01 23:13:33 UTC
Permalink
Raw Message
Another one is processing the DCOLLECT data with your SORT product, or MXG/SAS if you have it.
Post by Lizette Koehler
-----Original Message-----
On Behalf Of Lizette Koehler
Sent: Tuesday, August 01, 2017 4:13 PM
Subject: Re: JCL to get a report of large datasets
A good suggestion was using DFDSS
https://urldefense.proofpoint.com/v2/url?u=https-
3A__www.ibm.com_support_knowledgecenter_en_SSLTBW-
5F2.1.0_com.ibm.zos.v2r1.adru000_by.htm&d=DwICaQ&c=C3yme8gMkxg_i
hJNXS06ZyWk4EJm8LdrrvxQb-
Je7sw&r=u9g8rUevBoyCPAdo5sWE9w&m=ijoP2N00vfd6rQ9aeJomlK8VPBSv
VjXq4jN8vy-UkTE&s=-Lxof_rZ7zXBvGXILHUzO_I6fqhgyl-1G7-m1h3ld18&e=
You can filter by FSIZE Number of allocated or used tracks for the entire
data set on all the volumes on which it resides (data set size)
Remember to use PARM='TYPRUN=NORUN' to make sure you do not do any actual actions.
You can probably use DUMP or COPY for this process.
Lizette
-----Original Message-----
Sent: Aug 1, 2017 4:04 PM
Subject: Re: JCL to get a report of large datasets
I would write an REXX.
You could then specify the HLQ. And then use LISTC lvl("hlq") all
Run through the output finding the full DSN. Then use the LISTDSI to see
the size of the file.
If it matches your requirements, you can SAY the data.
This can be in a Batch TSO Step.
Or go to the CBTTAPE.ORG and see if there is a freeware function you can
use.
Lizette
-----Original Message-----
Sent: Aug 1, 2017 3:44 PM
Subject: Re: JCL to get a report of large datasets
Keeping it simple solution
1. OPTION 3.4
2. HLQ.* ( Make sure you have / Include Additional Qualifiers) 3.
Type SAVE <any name> and hit Enter 4. The list will be saved as
HLQ.anyname 5. View/Edit list dataset HLQ.anyname 6. Issue the command
SORT 75 87 D 7. You got the DSNAME and the tracks.
Note : This method is NOT applicable to migrated datasets.
You can run HLIST command on migrated datasets on LEVEL and get the
listing into a dataset.
Thanks,
Kolusu
Date: 08/01/2017 02:56 PM
Subject: Re: JCL to get a report of large datasets Sent by: IBM
Can i get a sample job or so to pull the information based on the
high-level qualifier of dataset ? Thanks!
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Alan Young
2017-08-02 00:19:09 UTC
Permalink
Raw Message
Post by Ron Thomas
Hi . Is there using utility job where i can use it pull all datasets that occupy huge space . Let me know how i can go ahead and do it .?
Regards
Ron T
Run ISMF (Naviquest) in ISPF batch mode. In the same step, run ACBQBAI2
to gather data and then ACBQBAR1 to create a report. See
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.idas200/s2137.htm
and
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.idas200/smsr.htm
for examples and JCL.

Alan

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Ron Thomas
2017-08-02 13:04:57 UTC
Permalink
Raw Message
Thanks everyone for the valuable information .

Regards
Ron T

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
Vince Coen
2017-08-02 13:12:10 UTC
Permalink
Raw Message
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
David Staudacher
2017-08-02 15:09:05 UTC
Permalink
Raw Message
Although DCOLLECT is restricted where I work, so I've never been able to actually use it, I believe it's the simplest and easiest option for this task, if available.
See DFSMS Data Collection Facility:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt2i2a1/11.0

For my own homegrown solution for this requirement, I use the UCBSCAN service to allocate each online volser (one at a time), then run through the DSCBs in each VTOC and write out the information I want, including the calculated size of each individual extent. Then, sorting the output by DSNAME and summing the extent sizes, I can obtain a precise value for the number of tracks used by each Dataset. Then, sorting by total size in descending order, I can identify the largest datasets on the entire system. For convenience, I also write the output to a .csv format file where it can then be easily manipulated for further analyis.

A detailed discussion of the development of this solution can be found here:
http://www.linkedin.com/groups/1462937/1462937-220206787
... along with some other goodies, such as how to use EXCP.

I can share the code for it if you like, but be forewarned it's written in Assembler, so the code is likely to be gibberish unless you have good understanding of the language. Nonetheless, if you don't mind Assemble the code with the standard IBM ASMA90 Assembler, and Bind (Link) it into a load library, it *will* run and *will* work.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@listserv.ua.edu with the message: INFO IBM-MAIN
w***@gmail.com
2017-08-04 08:55:19 UTC
Permalink
Raw Message
If you can install software then VTOC from file 112 at CBTTAPE.ORG is a good utility for what you want to do.
Loading...