Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 24 Feb 2004 @ 17:04:35 GMT

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

Subj:   Re: Script UNIX to disable users logons and kill active sessions
From:   Christopher Platt

.set titledashes off
.set foldline 1
.export report file /tmp/killout1
select distinct 'sel  host 100 '||
'kill session ' || cast(session_nbr as integer format '999999') (title '')
from dqmdb_oput.tcan000 ;
.if activitycount = 0 then .quit -1;

above sql creates input to xgtwglobal program below. it is my understanding that this will only kill network attached sessions. we have a seperate pgm that kills tso logged on sessions.

xgtwglobal -nw 


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019