|
View previous topic :: View next topic
|
| Author |
Message |
aditya_gorti
New User
Joined: 21 Dec 2005
Posts: 19
|
|
|
|
| I have many ALIAS for one particular user catalog. Can we delete one of those ALIAS without deleting the user catalog? |
|
| Back to top |
|
 |
cpuhawg
Active User
Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL
|
|
|
|
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 |
|
|
graswant
New User
Joined: 29 Apr 2006
Posts: 93
Location: Singapore
|
|
|
|
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 |
|
|
VIDHYA S
New User
Joined: 10 Apr 2008
Posts: 18
Location: chennai
|
|
|
|
| I would like to know whether it is possible to delete the dataset after deleting the alias.Kindly suggest me |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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 |
|
|
Bill Dennis
Active Member
Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA
|
|
|
|
| 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 |
|
|
graswant
New User
Joined: 29 Apr 2006
Posts: 93
Location: Singapore
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
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 |
|
|
graswant
New User
Joined: 29 Apr 2006
Posts: 93
Location: Singapore
|
|
|
|
Hey enrico-sorichetti
Thanks for the info...This is something new...I appreciate your efforts.... |
|
| Back to top |
|
|
VIDHYA S
New User
Joined: 10 Apr 2008
Posts: 18
Location: chennai
|
|
|
|
| Thanks.It is really useful.Our seniors have did the same process which i understood from your replies. |
|
| Back to top |
|
|
|
|
