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 !!!!
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.