Archives of the TeradataForum 
 
 
Message Posted: Sat, 21 Jan 2012 @ 10:15:06 GMT 
 
  
 
 
 
 
  
|  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 
 
 
 
 
   
 
 |