Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Oct 2012 @ 18:00:57 GMT


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


Subj:   Sessions in PMON
 
From:   JAMES PARK

Esteemed DBAs,

TD 13 on Windows

I was running updates on a table.

After the updates were done I checked PMON and saw the Total CPU of the session was still high. I expected the session gone right away.

But the PE State and AMP State were IDLE. This session was gone after a couple of minutes.

But I see a bunch of other sessions whose PE State and AMP State are IDLE.

My question is 'Can I abort the sessions whose PE State and AMP State are IDLE?'


Thanks,

James Park
Database Specialist II



     
  <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