IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Extracting a list of ALL DSN's on an LPAR


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
DaveV

New User


Joined: 12 Apr 2016
Posts: 7
Location: United States

PostPosted: Sun Feb 02, 2020 8:35 pm
Reply with quote

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
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 419
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Sun Feb 02, 2020 9:48 pm
Reply with quote

Be aware of SHARED volumes.

Did you search for solutions on these forums? Good info out there!
Back to top
View user's profile Send private message
DaveV

New User


Joined: 12 Apr 2016
Posts: 7
Location: United States

PostPosted: Sun Feb 02, 2020 10:12 pm
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany

PostPosted: Mon Feb 03, 2020 3:23 am
Reply with quote

Also you need to consider multivolume datasets whatever method of listing you choose.
Back to top
View user's profile Send private message
DaveV

New User


Joined: 12 Apr 2016
Posts: 7
Location: United States

PostPosted: Mon Feb 03, 2020 3:32 am
Reply with quote

What I'm after is a list of ALL datasets that I can download
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 917
Location: The Universe

PostPosted: Mon Feb 03, 2020 5:07 am
Reply with quote

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
View user's profile Send private message
DaveV

New User


Joined: 12 Apr 2016
Posts: 7
Location: United States

PostPosted: Mon Feb 03, 2020 5:17 am
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany

PostPosted: Mon Feb 03, 2020 12:38 pm
Reply with quote

You can go e.g. with ISMF (NAVIQUEST) and print the requested fields.

A search in the forum would have revealed http://ibmmainframes.com/about61210.html for your query.
Back to top
View user's profile Send private message
Apoorva

New User


Joined: 28 Jan 2020
Posts: 49
Location: India

PostPosted: Mon Feb 03, 2020 1:19 pm
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany

PostPosted: Mon Feb 03, 2020 1:54 pm
Reply with quote

@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
View user's profile Send private message
Apoorva

New User


Joined: 28 Jan 2020
Posts: 49
Location: India

PostPosted: Mon Feb 03, 2020 2:18 pm
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany

PostPosted: Mon Feb 03, 2020 3:09 pm
Reply with quote

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
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Mon Feb 03, 2020 9:42 pm
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1246
Location: Bamberg, Germany

PostPosted: Wed Feb 05, 2020 12:55 pm
Reply with quote

@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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Feb 14, 2020 4:21 pm
Reply with quote

IGGCSIRX in SYS1.SAMPLIB should do it all
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Help in extracting data between doubl... DFSORT/ICETOOL 5
No new posts Build dataset list with properties us... PL/I & Assembler 4
Search our Forums:

Back to Top