how to know which datasets are occupying more or max space

GANAPATH · New User Joined: 06 Mar 2006 Posts: 35

I have many datasets, more than 50,000 how can i find out which files are occupying more space, is there a simple command to know this or is there a JCl that i can run with the high level qualifier of my datset name.

Thanks,
Ganapath

expat · Posted: Mon Mar 19, 2007 9:50 pm

What DASD reporting software do you have, if any ?

Can't recall off the top of my head if DFdss (ADRDSSU) has the ability to select on size, but that may be worth investigating.

wanderer · Posted: Tue Mar 20, 2007 4:34 am

Just in case if they are all your datasets on your high level node, you can sort the list from ispf 3.4

DB2 Guy · New User Joined: 28 Oct 2008 Posts: 98 Location: Cubicle

Hi,

Do we really have some way of getting the size of DSNs as an application programmer?

expat · Posted: Fri Jan 23, 2009 5:28 pm

3.4 will give you sizes, DCOLLECT records will tell you, ISMF (if you have access) will tell you.

So yes, but depending on your security setup not all of the methods may be available.

What about the storage people, they should know

rajulan · New User Joined: 11 Jan 2008 Posts: 66 Location: India

ISPF- 3.4-It will list you the dataset name. Then In the command line just type SORT SIZE. Then you will come to know the size of the dataset. (descending order)

Thanks,
Rajulan.

DB2 Guy · New User Joined: 28 Oct 2008 Posts: 98 Location: Cubicle

Hi,

Thanks Big Brothers. That I understand - if we hit PF11 then too we can get those tracks details - something like:

Terry Heinze · Posted: Wed Jan 28, 2009 12:10 pm

Storage costs are going to be site dependent. How can you expect to get an answer to that from a public forum such as this?

expat · Posted: Wed Jan 28, 2009 12:18 pm

If your site has MXG or MICS installed then the DASD statistics are probably readily available. I did once write a SAS program to calculate tape storage (alas no longer with me) but as Terry has quite rightly pointed out - charges and costs are totally site dependant.

Anuj Dhawan · Posted: Wed Jan 28, 2009 2:52 pm

enrico-sorichetti · Posted: Wed Jan 28, 2009 2:54 pm

the ISMF dialogs, the ISMF dialogs, ..., the ISMF dialogs
and the relative reporting facilities

DB2 Guy · New User Joined: 28 Oct 2008 Posts: 98 Location: Cubicle

Calm down Big B...I know using ISMF I can get there; at my shop my RACF ID is allowed to issue "TSO ISMF" but I need to get these details for more than 10,000 DSNs.. and using this TSO command gives results very slow..

I've already suggested to my PM to get in touch with Storage Guys but we (us and storage guys) work in different time zones which is preventing us to get this exercise done little fast - and by the time I wanted to do put some efforts from my side..that's all.