Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 10375
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: 10375
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 TBSARG - Deleting the search criteria... ISPFHerc TSO/ISPF 5 Thu Dec 14, 2017 8:18 am
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us