Archives of the TeradataForum

Message Posted: Fri, 10 Nov 2006 @ 19:22:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I think SI (Session Information) under Teradata Manager allows you to abort by UserName.

PMON also allows you to do it indirectly. Instead of Aborting the session from the Session Detail (User) screen, you can abort sessions from the Session screen. Sort the sessions by UserName then highlight all your sessions (in the User listbox) and click Abort.

The bad news is that it will prompt you to confirm each abort ... so you have to click 'Yes' 50 times!

Finally, you can write your own monitor application (or use one of the sample applications that comes with Teradata Manager.) I think the Visual Basic and C++ samples both include Abort buttons.

All you would need to change is the line that says (in VB):

     Call gMonitor.AbortSession(mSess(i).HostId, mSess(i).SessionNum)

to

     Call gMonitor.AbortSession(mSess(i).HostId, mSess(i).UserName)

and that will abort all sessions for that user. (Unfortunately, due to a bug in older versions of the monitor object, this will not work until Teradata Manager 7.2 [TTU8.2] due out later this month.)

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>