Response Time, CPU Disk Ratio.

Database

Response Time, CPU Disk Ratio.

Hi ,

I am getting an error : 'Request aborted by TDWM. Exception criteria exceeded: Response Time, CPU Disk Ratio.'
while inserting data into the table .

can any one help me why this error occurred at insert query.

Thanks,
Nanda kishore
2 REPLIES
Enthusiast

Re: Response Time, CPU Disk Ratio.

Your Database Administrators have configured a rule (or rules) using Teradata Dynamic Workload Manager that your query exceeds. In this case there is a rule in place where the response time and ratio of CPU seconds to Disk IO exceeds a certain threshold. I would work with your DBA's to determine how these workload management rules are defined and how you can tune your query to operate within those rules. It may be a simple as moving to executing during a batch window where the rules are adjusted to accommodate this type of workload.
Enthusiast

Re: Response Time, CPU Disk Ratio.

Hi,

I got the same error : "Request aborted by TDWM. Exception criteria exceeded: Response Time."

The request has been delayed because I have defined a throttle on a query limit. But after 113s of delaytime,
TDWM has aborted it.

My question is : I would like to increase the delaytime duration. how can I change the timeout ?

Thanks