Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 28 May 2009 @ 20:25:44 GMT

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

Subj:   Re: Teradata Session Priority without PMON
From:   Dieter Noeth

Joerg Mutsch wrote:

  I was wondering if I can find out the priority for a Session / User within Teradata without using the PMON.  

  I was trying to find the information in one of the DBC Tables / Views (e.g. dbc.sessioninfo or dbc.sessioninfoX or dbc.sessioninfoV or dbc.sessioninfoVX) but I couldn't find anything.  

Hi Jvrg,

priority is determined by the accountstring and this is visible in dbc.sessioninfo.

But if the info provided by PMon is sufficient, then there's the new SQL interface in TD12. There's a MonitorSession/MonitorMySessions UDF in syslib, check the "Workload Management API" manual.


  <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