MVSFORUMS.com

pcsingh_2000 · Posted: Tue Mar 25, 2008 12:44 pm Post subject: REVOKE SYSADM FROM <USERID>;

Hi,

I have given SYADM authority to a userid. Through that userid, the user created many objects and had bind many packages.
Now when I tried to revoke the SYSADM auth from that user, the mainframe screen seems to be hanged and locked for hours. To get rid of this, I need to cancel the sysadm TSO id session in spool. Even once the subsystem was down.

Please help .. how can I achieve this?

Regards,
Prakash.
_________________
prakash c. singh
voice:00-91-93315 16675

kolusu · Posted: Tue Mar 25, 2008 1:06 pm Post subject:

pcsingh_2000,

Please search before posting. Check these links

http://www.mvsforums.com/helpboards/viewtopic.php?t=4662&highlight=sysadm

http://www.mvsforums.com/helpboards/viewtopic.php?t=4662&highlight=sysadm
_________________
Kolusu
www.linkedin.com/in/kolusu

pcsingh_2000 · Posted: Fri Mar 28, 2008 11:26 am Post subject:

Thanks for the input:

We made the Userid as Installation SYSADM id through one job which make the change in Z-Parm of DB2 subsystem.
Here is the member:
D710.DSN4.SDSNSAMP(DSNTIJUZ) -- second qualifier is the subsystem name.
and parameters are
SYSADM=TSGDSN4, -- put userid over here from which you want to revoke the SYSADM auth.
SYSADM2=TSGDSN4,

you need to stop/start the subsystem to make it effect. After that Shoot the REVOKE statement.

Regards,
Prakash.
_________________
prakash c. singh
voice:00-91-93315 16675