Archives of the TeradataForum

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

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

Hi,

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>		<<First	<Prev	Next>	Last>>