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
 

 

Can we delete Alias without deleting the user catalog

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
aditya_gorti

New User


Joined: 21 Dec 2005
Posts: 19

PostPosted: Tue Aug 22, 2006 8:09 pm    Post subject: Can we delete Alias without deleting the user catalog
Reply with quote

I have many ALIAS for one particular user catalog. Can we delete one of those ALIAS without deleting the user catalog?
Back to top
View user's profile Send private message

cpuhawg

Active User


Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL

PostPosted: Tue Aug 22, 2006 9:14 pm    Post subject: Re: Can we delete Alias
Reply with quote

As long as you have authority to delete an alias, you can do so. The user catalog will be unaffected.

Code:

//IDCAMS  EXEC PGM=IDCAMS                       
//* DELETE ALIASES                               
//SYSPRINT DD SYSOUT=*                           
//SYSIN DD *                                     
    DELETE XXXXXX ALIAS -                       
      CATALOG(MASTER.????.CATALOG/CANDLE)       
//                         


XXXXXX represents the ALIAS to be deleted. In order to delete an ALIAS, all dataset names associated with that ALIAS must be deleted first.
Back to top
View user's profile Send private message
graswant

New User


Joined: 29 Apr 2006
Posts: 93
Location: Singapore

PostPosted: Tue Sep 19, 2006 3:16 am    Post subject:
Reply with quote

Hi

If your Id has authority to delete the alias then you can do it. Go to 3.4 from ISPF pannel and type the Id for which you need to delet alias...you will be able to see the alias ....type Del beside it and enter...it will get deleted.....

Correct me if I am wrong...
Back to top
View user's profile Send private message
VIDHYA S

New User


Joined: 10 Apr 2008
Posts: 18
Location: chennai

PostPosted: Tue Apr 15, 2008 10:51 am    Post subject:
Reply with quote

I would like to know whether it is possible to delete the dataset after deleting the alias.Kindly suggest me
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Tue Apr 15, 2008 11:22 am    Post subject: Reply to: Can we delete Alias without deleting the user cata
Reply with quote

Quote:
would like to know whether it is possible to delete the dataset after deleting the alias.Kindly suggest me


Yes by pointing to the proper user catalog
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Tue Apr 15, 2008 6:40 pm    Post subject: Re: Can we delete Alias
Reply with quote

cpuhawg wrote:
In order to delete an ALIAS, all dataset names associated with that ALIAS must be deleted first.

No, the dataset names do not need to be deleted first but it's a good idea since you may lose track of which user catalog contains those entries.
Back to top
View user's profile Send private message
graswant

New User


Joined: 29 Apr 2006
Posts: 93
Location: Singapore

PostPosted: Tue Apr 22, 2008 3:13 pm    Post subject:
Reply with quote

Yeah Bill is right...Its better to delet the dataset names before deleting the alias...so that you don't need to keep a track of the user catalog.....well U can delete alias befor...its ur choice...by the way...why do you want to delet the alias first....Some reason?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Tue Apr 22, 2008 3:24 pm    Post subject: Reply to: Can we delete Alias without deleting the user cata
Reply with quote

The approach is just plain wrong...
if the catalog structure is properly setup the right approach is

delete the alias
export disconnect he catalog pointed by the alias

when and if the the datasets referred by the disconnected catalog are needed then

import connect the catalog
define the alias..

that' what is normally done during the process of software installation...

let' s take db2 for example ( rough approach )
the usual approach is to have 2 volumes
db8res target volume
db8dlb distribution volume

with a user catalog on the db8res ( let's say "catalog.db8res")
with an alias of dsn810 pointing to the catalog

when migrating to db2 version 9 for example
you could keep the same layout
( changing the 8 to a 9 )

when decommissioning version 8
delete the alias, export diconnect the v8 catalog, return the disks to the storage pool
why loose time deleting the single datasets ??
Back to top
View user's profile Send private message
graswant

New User


Joined: 29 Apr 2006
Posts: 93
Location: Singapore

PostPosted: Tue Apr 22, 2008 3:29 pm    Post subject: Hey
Reply with quote

Hey enrico-sorichetti

Thanks for the info...This is something new...I appreciate your efforts....
Back to top
View user's profile Send private message
VIDHYA S

New User


Joined: 10 Apr 2008
Posts: 18
Location: chennai

PostPosted: Tue Apr 22, 2008 3:33 pm    Post subject: Reply to: Can we delete Alias without deleting the user cata
Reply with quote

Thanks.It is really useful.Our seniors have did the same process which i understood from your replies.
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