While inserting records into a target table from source table using Bteq utility, I faced an error message like below, thus aborting the session.
*** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.
Almost 150 millions records (for 2 days) were expected to go in this session.
But when I am running the same Bteq for 1 day (roughly 75 million records), I am having no issues like above.
Can anyone please suggest how to go ahead on this with out DBA intervention.
This might be because of the session timeout set. there is a parameter like a system throttle which will abort any sessions which are logged on to the system for more than a specified period of time. This can also be a local parameter specified within the WLD for the workload to which the current user is assigned.