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

How to delete ONLY the alias dataset using TSO DELETE


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Rameshs

New User


Joined: 15 Jun 2005
Posts: 53
Location: India, Chennai

PostPosted: Mon Mar 19, 2007 5:18 pm
Reply with quote

Hi friends,

I have created an alias dataset using the following TSO command

TSO DEFINE ALIAS 'TSO***.TRG.ALIAS' RELATE('TSO***.TRG.UTIL')"

when i try to delete with

TSO DELETE 'TSO***.TRG.ALIAS' ALIAS

it's trying to delete the base dataset 'TSO***.TRG.UTIL'

How to delete only the alias entry ???
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Mon Mar 19, 2007 5:30 pm
Reply with quote

Dare I ask why you have used the *** in your commands ??? Or is this just to preserve your userid from being posted here.

Just set up and deleted an alais without any problems, both with and without the alias keyword specified.

Want to share your output with us ?

Are you sure that your define syntax is correct, because it's not like what's in the IDCAMS book.
Back to top
View user's profile Send private message
Rameshs

New User


Joined: 15 Jun 2005
Posts: 53
Location: India, Chennai

PostPosted: Mon Mar 19, 2007 5:35 pm
Reply with quote

This is my REXX code..I hope you understand

aliasds='tsoxxx.rexx.alias' /* Alias dataset name */
realds='tsoxxx.rexx.source' /* Real Dataset name */
address tso
"DEFINE ALIAS( NAME('"aliasds"') RELATE('"realds"'))"

Now i want to delete only the aliast dataset.. Please suggest
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Mon Mar 19, 2007 5:40 pm
Reply with quote

DELETE 'aliasds' works for me
Back to top
View user's profile Send private message
Rameshs

New User


Joined: 15 Jun 2005
Posts: 53
Location: India, Chennai

PostPosted: Mon Mar 19, 2007 5:51 pm
Reply with quote

Hi,

Yes it's working fine if the realds is my own PDS ....But if the realds is another person's PDS, then i am getting the following error.

I gave TSO DELETE <alias dataset>, i got the following error

TSS7227E SCRATCH Access Not Granted to Dataset TSO***.REXX.SOURCE
IDC3018I SECURITY VERIFICATION FAILED+

Note:TSO***.REXX.SOURCE is real dataset (other's PDS)

Please suggest
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Mar 19, 2007 6:28 pm
Reply with quote

the message was issued by the security manager, TOP secret i guess by the "TSS" message prefix
the meaning is self explanatory

The best suggestion You can get is:
do not play around with somebody's else datasets, unless your job description takes into account such activity...

The security auditors are usually upset by these things and if You do not give them good reasons for your actions You are going to get in very deep trouble.
In many countries repeated security violations (or attempts like in this case) constitute a lawful reason for termination ( getting fired ).

You are warned :-)

[/b]
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Mon Mar 19, 2007 6:31 pm
Reply with quote

Yes, and the message tells you why it has failed.

You do not have the authority to do things with other peoples datasets.

Did it allow you to define the alias to another users PDS ?
It may be because you require different levels of access to define and delete an alias.

Might be worth asking your security people about that, as that is not something I have played with for many years now.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Mar 19, 2007 8:05 pm
Reply with quote

Hello,

Is there some business reason to create an alias fro some one else's dataset? Is there some business reason that the dataset should have an alias at all?

You are definitely "fishing in restricted water". As Enrico said
Quote:
You are warned :-)
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 -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
Search our Forums:

Back to Top