list all TASM delayed queries for a user over a specific time period

General
Teradata Employee

list all TASM delayed queries for a user over a specific time period

Hi

is there a way to list all TASM delayed queries for a user over a specific time frame? Rewind seems to be a difficult choice here as it gives me the information at a particular moment and not over a specific period.I am looking to sort of generate a report listing specific userID's and how frequently have there sessiosn gone in delay state over the last month or so !!!!  Please help !!!!

2 REPLIES
Enthusiast

Re: list all TASM delayed queries for a user over a specific time period

Look at delaytime in dbqlogtbl.  If it has a value > 0 then the query was delayed, and it also shows how long it was delayed for.

There are also other columns that may be useful - tdwmruleid to show which rule applied to the query; TDWM estimate columns to show the estimated values for CPU, IO, runtime, etc. which determined the rule; WDID and FinalWDID that show the first and the last workload the query ran in.

Teradata Employee

Re: list all TASM delayed queries for a user over a specific time period

Perfect Andy , Thank you very much !!!!