How to get details of all sessions using MONITOR SQL

Database
Highlighted
Enthusiast

How to get details of all sessions using MONITOR SQL

Hi,

 

I am using Teradata PMPC API MONITOR SQL to get current sql execution step information for a session id. Is there any API to get sql executions of all sessions directly instead of iterating over each session?

 

Appreciate your help!

 

Thanks

 


Accepted Solutions
Teradata Employee

Re: How to get details of all sessions using MONITOR SQL

No, the API only allows fetching that detail for one session at a time.

1 ACCEPTED SOLUTION
5 REPLIES
Teradata Employee

Re: How to get details of all sessions using MONITOR SQL

No, the API only allows fetching that detail for one session at a time.

Enthusiast

Re: How to get details of all sessions using MONITOR SQL

How is teradata viewpoint fetching the details of all sessions at once?

Teradata Employee

Re: How to get details of all sessions using MONITOR SQL

It doesn't. 

The collector iterates through the sessions, and writes the information to a database on the Viewpoint server itself.

The portlets fetch previously collected monitor data from the local database.

Enthusiast

Re: How to get details of all sessions using MONITOR SQL

Ok cool. Thanks for the info.

Enthusiast

Re: How to get details of all sessions using MONITOR SQL

One more quick question, is EstElapTIme and ActElapTIme given by monitor sql in seconds or minutes?