Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Aug 2003 @ 15:37:03 GMT


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


Subj:   Re: Sessions holding locks after query completes?
 
From:   John Hall

I'm sure that this request seems redundant, but when your problem session is logged-on and holding a lock, would you run the following query for the user in question?

sel sessionno
  , options

  from dbc.sessions

  where username = 

  order by 1;

The point of this is that character 1 of OPTIONS indicates the current session mode (call me paranoid, but what it's supposed to be may not match the actual setting):

'A' = ANSI
'T' = Teradata

FWIW: character 2 of OPTIONS indicates the current 2PC mode:

'2' = 2 phase commit
'N' = Non-2 phase commit



     
  <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