Will the TASM counts the 'responding' queries along with the active queries/sessions into the count of Throttles limits of the workload ?
we have an application for which queries are spending long time in respose state ( large data extracts ). In this case, will these responding sessions also be accounted for throttle limit ?
Any documention mentioned about how TASM handles the throttle counts based on the session state could be helpful ? Appreciate your quick response...
No, "responding" sessions do not count against a throttle. I can see how that might not be clear, since the manuals tend to refer to "concurrently executing" requests rather than specifically the "active" AMP state. The Orange Books (available from Teradata at Your Service or your Teradata representative) have more detail.