View previous topic :: View next topic
|
Author |
Message |
DaveV
New User
Joined: 12 Apr 2016 Posts: 7 Location: United States
|
|
|
|
Hi all - I need to extract a list of ALL datasets on an LPAR. We have a messy system we need to clean up abandoned stuff from agencies that have departed. I know how to do this with LISTCAT on each individual catalog, but I would like a "flat" file that I can download to my PC and organize/interrogate with tools. The output from LISTCAT is also multi-line and does not easily lend itself to organized queries. The info I need is name, date created, last date referenced and size. Anyone have any ideas/tricks to do this? Thanks! |
|
Back to top |
|
|
dneufarth
Active User
Joined: 27 Apr 2005 Posts: 420 Location: Inside the SPEW (Southwest Ohio, USA)
|
|
|
|
Be aware of SHARED volumes.
Did you search for solutions on these forums? Good info out there! |
|
Back to top |
|
|
DaveV
New User
Joined: 12 Apr 2016 Posts: 7 Location: United States
|
|
|
|
THX- not sure what exact search term(s) to use but I will poke around...Maybe I can use the output from "3.4" - data set listing using a wildcard?. .? |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
|
|
|
|
Also you need to consider multivolume datasets whatever method of listing you choose. |
|
Back to top |
|
|
DaveV
New User
Joined: 12 Apr 2016 Posts: 7 Location: United States
|
|
|
|
What I'm after is a list of ALL datasets that I can download |
|
Back to top |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
DaveV wrote: |
What I'm after is a list of ALL datasets that I can download |
Download? I thought the idea was to locate abandoned data sets, not steal what may still be proprietary data! |
|
Back to top |
|
|
DaveV
New User
Joined: 12 Apr 2016 Posts: 7 Location: United States
|
|
|
|
No, I would like to get a flat list of ALL datasets catalogued on the LPAR (as well as uncatalogued ones) if I can that I can download. We can tell what is "abandoned" by various qualifiers and dates. |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
|
|
Back to top |
|
|
Apoorva
New User
Joined: 28 Jan 2020 Posts: 49 Location: India
|
|
|
|
DaveV wrote: |
No, I would like to get a flat list of ALL datasets catalogued on the LPAR (as well as uncatalogued ones) if I can that I can download. We can tell what is "abandoned" by various qualifiers and dates. |
LISTCAT will work only for Catalogued datasets, and not for uncatalogued datasets. If you want a list of ALL datasets (catalogued and uncatalogued) you may have to follow below 2 steps using Assembler,
1. Run UCBSCAN macro to extract ALL ONLINE DASD volumes on the system.
2. Then run CVAFFILT macro against each DASD volume to read DSCB-1/DSCB-8 from VTOC dataset.
I will see if I have any program in my repository to read VTOC on all online DASD volumes, and will give you more details. |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
|
|
|
|
@Apoorva: I would use IDCAMS DCOLLECT as this is an official IBM supported product. It is also mentioned in the Link I provided. |
|
Back to top |
|
|
Apoorva
New User
Joined: 28 Jan 2020 Posts: 49 Location: India
|
|
|
|
Joerg.Findeisen wrote: |
@Apoorva: I would use IDCAMS DCOLLECT as this is an official IBM supported product. It is also mentioned in the Link I provided. |
Yes right. I read about DCOLLECT now (as I wasn't aware about DCOLLECT earlier), and apparently it does everything (and even more) that I mentioned in my previous post. So, VOLUMES(**) could be used to collect information from all online DASD volumes right? |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
|
|
|
|
That's correct. Something like this snippet should be able to collect raw data.
Code: |
DCOL +
OFILE(DCOUT) +
VOL(*) +
EXV($*,HSML1*) +
NOV |
The second step in general is used, with whatever method preferred, to process the data. In my case I would run a SORT. |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 734 Location: Denmark
|
|
|
|
The VTOC command from cbttape.org file 112 is very good for what you want. It is based on listing VTOC(s) of course, but has an option to tell if the dataset is cataloged. |
|
Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
|
|
|
|
@Willy: You can take file 035 for the compiled version. It seems to have some issues with ENQ option and large datasets. Other than that it looks good. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
IGGCSIRX in SYS1.SAMPLIB should do it all |
|
Back to top |
|
|
|