View previous topic :: View next topic
|
Author |
Message |
kumjara
New User
Joined: 04 Feb 2008 Posts: 5 Location: India
|
|
|
|
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 |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
If I say yes... what will you do after get it?
Why do you want it? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
kumjara
New User
Joined: 04 Feb 2008 Posts: 5 Location: India
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Why do you need to know the catalog names if you know the HLQ for the UAT environment |
|
Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2547 Location: Silicon Valley
|
|
|
|
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 |
|
|
nevilh
Active User
Joined: 01 Sep 2006 Posts: 262
|
|
|
|
could you use idcams....... listc ucat |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
kumjara
New User
Joined: 04 Feb 2008 Posts: 5 Location: India
|
|
|
|
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 |
|
Back to top |
|
|
|