Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 Oct 2008 @ 11:01:50 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Getting a session's own resource info
From:   Levai Akos


I would like to get a session's consumed resource info (CPU, IO and so on...), within the session through SQL.

It would be important for me the the session sould get these informations itself, and write it to the output.

I would not like to use the DBQL, because the overhead, and the offline postprocessing (matching the query with the DBQL log)

Can anyone give me some informations about?

- Is it possible at all?

- If the data is not available through dictionary tables do I have any possibility to access it from SQL (with some UDF, calling external API program eg.)

- or I can just have the MONITOR SESSION possibility through CLI2 API?

- Do I have to use the DBQL by all?

Than you in advance!

Levai Akos

  <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