Archives of the TeradataForum

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

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

.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>>