Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 21 Jan 2012 @ 10:15:06 GMT


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


Subj:   Explanation for this blocked session: Artificial session
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, January 20, 2012 22:58 -->

Hi Folks

I am running a query against DBQLogTbl and soon as I do, I see that the ?user DBC is being blocked by my ID. More details from PMON reveal that lock requested by "selected session is Lock mode :read, status : granted".

Against DBC session info details I see this "Artificial session , blocker information for all internal DBQL and TWM requests"

Just what is this session and any explanation. I've never seen it before . Is it something done by TWM



     
  <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