Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to get the list of catalogs available in any mainframe?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
kumjara

New User


Joined: 04 Feb 2008
Posts: 5
Location: India

PostPosted: Fri Oct 28, 2011 7:21 pm    Post subject: how to get the list of catalogs available in any mainframe?
Reply with quote

I need to know all the catalog names available in my mainframe system.

Do we have any Utility to list down all the catalogs names?
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Oct 28, 2011 7:25 pm    Post subject: Reply to: how to get the list of catalogs available in any m
Reply with quote

If I say yes... what will you do after get it?
Why do you want it?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 28, 2011 7:29 pm    Post subject:
Reply with quote

Obviously you want to do this using REXX because you have posted in that forum .... Correct ?

Would LISTCAT be a good place to start I wonder
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Fri Oct 28, 2011 7:39 pm    Post subject: Reply to: how to get the list of catalogs available in any m
Reply with quote

I'm also curious as to why you'd need to know. The catalog(s) you use, you don't need to know of. Looking for catalogs that you don't use... could look snooping to some.

If you are a storage person, ask a colleague. If you're not (and your profile doesn't seem to indicate that) then what is the reason you need to know? If it is a good reason, ask your storage people.
Back to top
View user's profile Send private message
kumjara

New User


Joined: 04 Feb 2008
Posts: 5
Location: India

PostPosted: Fri Oct 28, 2011 7:51 pm    Post subject:
Reply with quote

Quote:

Obviously you want to do this using REXX because you have posted in that forum .... Correct ?


Yes. I prefer to do it through REXX .

Quote:

If I say yes... what will you do after get it?
Why do you want it?

I need to find the list of catalogs for this below requirement.
To do the dataset cleanup in the UAT environment. Based on the catalog name, i can LISTCAT the datasets, then analyse its usage to recommed deletion
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 28, 2011 7:56 pm    Post subject:
Reply with quote

Why do you need to know the catalog names if you know the HLQ for the UAT environment
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2019
Location: Silicon Valley

PostPosted: Fri Oct 28, 2011 9:35 pm    Post subject: Reply to: how to get the list of catalogs available in any m
Reply with quote

It is not clear what the 'UAT environment' is. If you know the high level qualifiers, then you can just list its datasets without knowing the catalog name.

If your site is not well managed, you may have randomly named datasets...

You may want to start with one of the user volumes...
1. display the datasets on volume with ISPF 3.4 and only specify the volid.
2. look at each high level qualifier. Again, use LISTCAT to display all of that HLQ's datasets. It will be hard to determine what is good and what is not.

For datasets not cataloged, maybe you should rename, archive, and delete after some period.

I long ago forgot the fine details, but you may need to turn on the 'protectall' option of RACF. I think it forces each dataset to have a RACF defined userid or group name as a high level qualifier. In that way, each dataset will have a owner and you can have them decide what is needed and what can be deleted.
Back to top
View user's profile Send private message
nevilh

Active User


Joined: 01 Sep 2006
Posts: 258

PostPosted: Fri Oct 28, 2011 10:26 pm    Post subject:
Reply with quote

could you use idcams....... listc ucat
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 28, 2011 10:49 pm    Post subject:
Reply with quote

Or you could research Dfdss which has good date filtering capabilities and also take a backup of any files that you delete is always a good idea.

However, the real solution would be to liaise with your storage management team to use the tools already in place to do all of this automatically. DFsms and DFhsm are brilliant tools for doing all of this malarky.
Back to top
View user's profile Send private message
kumjara

New User


Joined: 04 Feb 2008
Posts: 5
Location: India

PostPosted: Mon Oct 31, 2011 3:05 pm    Post subject:
Reply with quote

The Catalog search Interface - IGGCSIRX is satisfying my requirement. The filter Key ** is performing search in all catalogs(System & User catalogs)
Code:

//STEP001  EXEC PGM=IKJEFT1B                                     
//SYSTSPRT DD DSN=XXXXXXX.CATALOG.SEARCH.OUTPUT,                 
//            DISP=(NEW,CATLG,DELETE),                           
//            UNIT=SYSDA,SPACE=(CYL,(100,100),RLSE)             
//SYSTSIN  DD *                                                 
EXEC 'SYS1.SAMPLIB(IGGCSIRX)' EXEC                               
**                                                               
/*                                                               


This utility is able to list down the catalogs name, followed by the datsets and their volume. A sample Output attached below.


Code:

READY                                                                 
EXEC 'SYS1.SAMPLIB(IGGCSIRX)' EXEC                                     
ENTER FILTER KEY                                                       
CATALOG  SYS1.VOLCAT.V6                                               
                                                                       
         CLUSTER  ............................................         
         DATA     SYS1.VOLCAT.V6                               UPSY05 
         INDEX    SYS1.VOLCAT.V6.CATINDEX                      UPSY05 
         CLUSTER  SYS1.VVDS.VUPSY05                                   
         DATA     SYS1.VVDS.VUPSY05                            UPSY05 
CATALOG  SYS1.VOLCAT.XXXXX                                         
                                                                       
         CLUSTER  ............................................         
         DATA     SYS1.VOLCAT.XXXXX                         UPSY05 
         INDEX    SYS1.VOLCAT.XXXXX.CATINDEX                UPSY05 
         CLUSTER  SYS1.VVDS.VUPSY05                                   
         DATA     SYS1.VVDS.VUPSY05                            UPSY05 
                                     


The utility is executing for a long time.

Appreciate all your responses and suggestions. It's helpful to explore icon_smile.gif
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Admin Openings with CTS enikhilk Mainframe Jobs 0 Tue Sep 13, 2016 10:13 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us