JCL to get a report of large datasets

Discussion:

(too old to reply)

Ron Thomas

2017-08-01 20:54:13 UTC

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

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

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 .?

Ron Thomas

2017-08-01 21:54:43 UTC

Permalink

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

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,

Lizette Koehler

2017-08-01 23:03:41 UTC

Permalink

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!

Lizette Koehler

2017-08-01 23:11:54 UTC

Permalink

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-----

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!

Gibney, Dave

2017-08-01 23:13:33 UTC

Permalink

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-----

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

Alan Young

2017-08-02 00:19:09 UTC

Permalink

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

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

David Staudacher

2017-08-02 15:09:05 UTC

Permalink

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

If you can install software then VTOC from file 112 at CBTTAPE.ORG is a good utility for what you want to do.