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

Process to Delete USER CATALOG


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prasad029

New User


Joined: 15 May 2007
Posts: 16
Location: bangalore

PostPosted: Wed Nov 09, 2011 4:07 pm
Reply with quote

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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Nov 09, 2011 4:15 pm
Reply with quote

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

New User


Joined: 15 May 2007
Posts: 16
Location: bangalore

PostPosted: Wed Nov 09, 2011 4:32 pm
Reply with quote

thank you for the reply.
This UCAT is an obselete one and already backed up as per site standards.

Regards,
Prasad
Back to top
View user's profile Send private message
nevilh

Active User


Joined: 01 Sep 2006
Posts: 262

PostPosted: Wed Nov 09, 2011 4:37 pm
Reply with quote

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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Nov 09, 2011 4:40 pm
Reply with quote

what about ...
DELETE '<catname>' USERCAT

from ISPF option 3.4 just use the line command
DELETE / USERCAT
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 09, 2011 4:42 pm
Reply with quote

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

New User


Joined: 15 May 2007
Posts: 16
Location: bangalore

PostPosted: Wed Nov 09, 2011 7:18 pm
Reply with quote

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

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 09, 2011 10:38 pm
Reply with quote

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

Global Moderator


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

PostPosted: Wed Nov 09, 2011 11:26 pm
Reply with quote

Peter, maybe he knows the PW icon_lol.gif

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

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Nov 09, 2011 11:51 pm
Reply with quote

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

Global Moderator


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

PostPosted: Thu Nov 10, 2011 1:06 am
Reply with quote

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 icon_lol.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Nov 10, 2011 1:10 am
Reply with quote

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

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Nov 10, 2011 8:23 pm
Reply with quote

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

Active Member


Joined: 31 Dec 2009
Posts: 580
Location: London

PostPosted: Thu Nov 24, 2011 10:44 pm
Reply with quote

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
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts user exit in IBM Infosphere Optim DB2 8
Search our Forums:

Back to Top