All Forums Viewpoint
HarshaKudumula 83 posts Joined 04/09
11 May 2016
Is there a way to control RESPONDING STATE of large extracts using TASM Exceptions?

Hi All,
Is there a way to control RESPONDING STATE of large extracts using TASM Exceptions? i know we can use IO Physical Bytes but it is umbrella for all kind of activites like spool across joins, duplications, responding, etc.
I am struggling to find on how to control this.
 
 
Thanks,
Harsha.

Glass 225 posts Joined 04/10
16 May 2016

Harsha,
when you say control what do you mean? Since the query execution has completed you can only let it finsh responding or abort.
You can abort using a session alert if your versions supports.
 
Rglass

ToddAWalter 316 posts Joined 10/11
16 May 2016

What is the goal?  What are you trying to manage?

manishdasin 6 posts Joined 01/12
04 Aug 2016

No. 
If you could mention your goal, we may think of options.

LUCAS 56 posts Joined 06/09
30 Aug 2016

Hi all,
i'm just looking for a clarification about the Spool displayed in Viewpoint portlet Query Monitor when a session is in a "response" state:
Is that spool a Bynet owned spool, as a buffer ? or the ultimate estimation of spool when the last AMP sent the data to bynet ?
Since the query is over i think it is not a remaining Spool for the user and it is not part of the Spool space limit, may be i'm wrong ?
Pierre 

ToddAWalter 316 posts Joined 10/11
30 Aug 2016

The result spool is not sent to BYNet. The BYNet is sent a reference to it where it was created by the last step of the plan. The result spool stays in the user's spool space until it is released by the application and is part of the user's spool space limit until then.

LUCAS 56 posts Joined 06/09
30 Aug 2016

OK Todd, 
so we experience an issue with ETL sessions remaining in response for hours (and days), each of them with big spool ...
Thanks for clarification,
Pierre
 

You must sign in to leave a comment.