Archives of the TeradataForum
Message Posted: Thu, 16 Oct 2008 @ 11:01:50 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|