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
 

 

Process to Delete USER CATALOG

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Process to Delete USER CATALOG
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7236

PostPosted: Wed Nov 09, 2011 4:15 pm    Post subject: Reply to: Process to Delete USER CATALOG
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    Post subject: Reply to: Process to Delete USER CATALOG
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: 258

PostPosted: Wed Nov 09, 2011 4:37 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Wed Nov 09, 2011 4:40 pm    Post subject: Reply to: Process to Delete USER CATALOG
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: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 09, 2011 4:42 pm    Post subject:
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    Post subject: Reply to: Process to Delete USER CATALOG
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: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Nov 09, 2011 10:38 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Nov 09, 2011 11:26 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Wed Nov 09, 2011 11:51 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Thu Nov 10, 2011 1:06 am    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Thu Nov 10, 2011 1:10 am    Post subject:
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

Senior Member


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

PostPosted: Thu Nov 10, 2011 8:23 pm    Post subject:
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 User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Thu Nov 24, 2011 10:44 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts SORT - E15 and E35 using same user ex... Abhi Nature DFSORT/ICETOOL 12 Mon Oct 03, 2016 4:33 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts User exit in COBOL programs ganasrinivasan PL/I & Assembler 0 Thu Aug 18, 2016 12:48 pm


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