Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Extracting a list of ALL DSN's on an LPAR

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
DaveV

New User


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

PostPosted: Sun Feb 02, 2020 8:35 pm    Post subject: Extracting a list of ALL DSN's on an LPAR
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: 313
Location: Inside the SPEW (Cincinnati OH USA)

PostPosted: Sun Feb 02, 2020 9:48 pm    Post subject:
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: 5
Location: United States

PostPosted: Sun Feb 02, 2020 10:12 pm    Post subject:
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

Active User


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

PostPosted: Mon Feb 03, 2020 3:23 am    Post subject:
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: 5
Location: United States

PostPosted: Mon Feb 03, 2020 3:32 am    Post subject:
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: 823
Location: The Universe

PostPosted: Mon Feb 03, 2020 5:07 am    Post subject:
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: 5
Location: United States

PostPosted: Mon Feb 03, 2020 5:17 am    Post subject: Reply to: Extracting a list of ALL DSN's on an LPAR
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

Active User


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

PostPosted: Mon Feb 03, 2020 12:38 pm    Post subject:
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: 33
Location: India

PostPosted: Mon Feb 03, 2020 1:19 pm    Post subject: Re: Reply to: Extracting a list of ALL DSN's on an LPAR
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

Active User


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

PostPosted: Mon Feb 03, 2020 1:54 pm    Post subject:
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: 33
Location: India

PostPosted: Mon Feb 03, 2020 2:18 pm    Post subject:
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

Active User


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

PostPosted: Mon Feb 03, 2020 3:09 pm    Post subject:
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 User


Joined: 01 Sep 2015
Posts: 362
Location: Denmark

PostPosted: Mon Feb 03, 2020 9:42 pm    Post subject:
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

Active User


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

PostPosted: Wed Feb 05, 2020 12:55 pm    Post subject:
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: 8795
Location: Welsh Wales

PostPosted: Fri Feb 14, 2020 4:21 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PKZIP - extracting multiple txt files drarem All Other Mainframe Topics 3 Tue Jul 07, 2020 8:47 pm
No new posts Need help in REXX code to list the af... chavinash2004 CLIST & REXX 3 Wed Apr 01, 2020 12:53 pm
No new posts Dynamically split large DSN list into... Ghellar CLIST & REXX 14 Tue Sep 17, 2019 8:24 pm
No new posts recursive SQL to generate list jzhardy DB2 5 Sun Apr 07, 2019 8:38 am
No new posts Silly question maybe - REPLACE member... Cloink TSO/ISPF 15 Thu Oct 25, 2018 6:38 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us