Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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:
     Database: DIGITAL_WRK                     Table:

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023