Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Aug 2003 @ 21:13:52 GMT


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


Subj:   Re: Killing queries
 
From:   Adam DeYoung

I would use PMON for no other reason than with the newer PMON you can see the SQL that session is currently performing. If it were an insert, update or some other SQL that could potentially cause a painfull rollback we would not kill it but rather get to work figuring out how long this request will take to complete, and whether it was worth altering their Priority Scheduler settings to decrease their impact on the system while running.

With Gtwglobal you kill the session and hope a big rollback did not just start. You want to avoid rollbacks at all costs.

Adam
Advanced Certified Teradata Professional



     
  <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: 15 Jun 2023