Archives of the TeradataForum

Message Posted: Thu, 24 Feb 2005 @ 19:21:43 GMT

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

Log onto the database where the session(s) are running and get both the <sessionno> and <hostid> for the ones you want aborted:

     Select * from dbc.sessioninfo;

Log in as root on anyone of the TPA Unix nodes.

Then at the Unix prompt enter the command cnsterm 6 <enter>

This puts you in the Supervisory command window.

The abort session command has many options, this is one way

     abort session : logoff override 


          Example: abort session 1:83661 logoff override

You can see other abort session options with the help command:

     Help abort 

When your done aborting the sessions, most likely you will need to enter

Cntl-Z to exit cnsterm

Regards,

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters

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