Viewing Queries

Viewpoint

Viewing Queries

We have several queries that sometimes get stuck in response mode. Is there a way to real time see what the queryid is of a query that is currently in response mode? Using the following:

SEL a.*,

    b.sqlrowno,

    b.sqltextinfo

FROM dbc.qrylog a

     LEFT OUTER JOIN dbc.qrylogsql b

       ON a.queryid = b.queryid

      AND a.procid = b.procid;

I can see queries in the past (about a 15 minute delay) but i'm looking for real time based on sessions. I want to be able to see the currently executing query that is in response mode. Viewpoint does not show the sql or any information on the query when it is in response mode and if it's a query that executes fast but returns billions of row using the rewind feature doesn't capture the query either.

Any advice or idea's on this?

Tags (3)
2 REPLIES
Teradata Employee

Re: Viewing Queries

There's not much that can be done to address this in Viewpoint.  Once the query finishes execution and is in responding mode, the SQL is no longer available from the database.

Re: Viewing Queries

Hello,

the sessions in the state 'ResponseTime' are very disadvantageous, particularly when they remain in this state for several hours ...

How to get an alert with Viewpoint (14.10) ?