Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2010 @ 14:42:23 GMT


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


Subj:   Lock Display Utility
 
From:   Barner, Eric

I have a question regarding the Lock Display Utility and the data being returned from the utility.

I want to use it to figure out exactly what tables are being MLoaded/Fastloaded, and which sessions are responsible.

I can tell from the transactions locks what tables are being locked, but I have an issue trying to interpret the session Returned by Lock Display.

Given this example using the TRAN command and selecting an amp, I get the following output.

     Tran: 16379 2F2D58D6
     Host:  1025 Session:   144,52288 Mode: EX   User:
     DIGITAL_LOAD01
     Database: DIGITAL_WRK                     Table:
     WT_CPM_SUM_FACT_OUT

I get representation of the Tran: line . (PE) (Tranaction ID in hex)

How do I convert the Session: 144,52288 into a meaningful session id as displayed by dbc.sesssioninfo???

I suppose these may be hex representations as they are both evenly divisible by 16.

     144/16 = 9
     52288  = 3268

But I am not able to match up these numbers (by multiplying , adding, otherwise) with the session ids as reported by dbc.sesssioninfo..

Does someone have the formula to do so properly?


Thanks for the help in advance.

Eric W. Barner



     
  <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