Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2004 @ 14:21:16 GMT


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


Subj:   Closing ghost session
 
From:   Kepinski, Marek

Hi,

I have a session started 3 days ago, which actually does nothing but its state in displayed as AMP State = IDLE and PE State = ABORTING in Performance Monitor. This session is blocking any possible operations on some table and it is not possible to abort the session. Only SELECT statement runs on the table. Also it is not possible to drop the table.

Is there any way to close the session? I restarted the computer that was a logon source for this session but this also didn't help. Any ideas?


TIA,

Marek



     
  <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: 27 Dec 2016