View previous topic :: View next topic
|
Author |
Message |
prasad029
New User
Joined: 15 May 2007 Posts: 16 Location: bangalore
|
|
|
|
Hi All,
Can any one please let me know the process to be followed to DELETE a USER CATALOG.
Thanks and Regards,
Prasad |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Let everyone know that it is going to happen, and when.
Provide an alternative catalog to use (optional).
At the "when", back it up to site standards.
Delete it.
Spend the first hour of the following Monday waiting for the 'phone to ring.
It goes without saying, but here it is, you also test everything first. You test the backup, by ensuring that you can restore it. Checking all output messages, check that same amount of space is used, following-up on anything you don't understand. You need a clean backup/restore before you consider the delete.
To test the delete, define a new catalog. Catalog some datasets to it. Back it up. Delete it. Restore it. Delete it.
On the other hand, why are you doing it? Don't you have some storage people whose job it is to do stuff like that? |
|
Back to top |
|
|
prasad029
New User
Joined: 15 May 2007 Posts: 16 Location: bangalore
|
|
|
|
thank you for the reply.
This UCAT is an obselete one and already backed up as per site standards.
Regards,
Prasad |
|
Back to top |
|
|
nevilh
Active User
Joined: 01 Sep 2006 Posts: 262
|
|
|
|
Beware ........ any Vsam clusters that are owned by the user catalog will also be deleted. Check the contents of the User Catalog to be deleted. You will be suprised how many "obsolete" catalogs are still the owner of Vsam Clusters. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
what about ...
DELETE '<catname>' USERCAT
from ISPF option 3.4 just use the line command
DELETE / USERCAT |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Probably your master catalog is pw protected, and there will be no one to tell you that pw. So since you only browse, let the people who know handle that. |
|
Back to top |
|
|
prasad029
New User
Joined: 15 May 2007 Posts: 16 Location: bangalore
|
|
|
|
Hi I did the below:
1. Removed the Datasets and Alias related to the UCAT
2. Deleted the UCAT using IDCAMS DELETE.
Regards,
Prasad |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
That sounds great, deleting a ucat without a master catalog pw. Now try to delete the master catalog, that will be funny if its not pw protected. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Peter, maybe he knows the PW
Just a case of going around and checking that there are no entries related to the catalog still exist in all of the VVDS on the system.
Usually a few laying about after a UCAT delete, and they crop up with errors from time to time too. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
Usually a few laying about after a UCAT delete, and they crop up with errors from time to time too. |
Hoo-boy, do I remember that! I defined a TSO HLQ one time and forgot to put in the REL(usercat). They didn't have write access to the master catalog, so there wasn't much they could do on the system! It took a couple of looks to figure out what I'd done wrong. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
I recall biffing a UCAT and for some strange reason (read user error) where he'd left a STEPCAT in the job, and could I get rid of that particular dataset.
Well, Yes, of course I could, but it did take a while.
Robert, admitting to a mistake. Oh God, does this really mean that sysprogs are only human too |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
I told an application programmer one time the main difference between their job and mine was that when they made a msitake, it would be known by the on-call person and themselves whereas when I made a mistake, EVERYBODY knew about it! |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Robert Sample wrote: |
I told an application programmer one time the main difference between their job and mine was that when they made a msitake, it would be known by the on-call person and themselves whereas when I made a mistake, EVERYBODY knew about it! |
I was listening it, when you said it to me. |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 592 Location: London
|
|
|
|
Don't forget to EXPORT DISCONNECT the Usercatalog from any other alternate Mastercatalogs
ps: Be VERY afraid of using the FORCE parameter when deleting a Usercatalog! Had a weekend competely ruined by that about 20 years ago. |
|
Back to top |
|
|
|