Skip to Content
0

IDLE, RUNNING and ACTIVE statement states

Jun 28, 2017 at 09:07 PM

61

avatar image

Hi,

I was hoping someone could shed some light on this idea of thread states in HANA.

Basically my question is aimed at finding out when HANA changes the state of a thread to IDLE. This also ties into the parameter idle_cursor_timeout.

1: If I set this parameter to lets say 10 seconds, in theory this should cancel the thread/query which runs longer than 10 seconds, Is this assumption correct?

2: To go deeper, I would assume that this parameter only targets IDLE connections (again open to correction here?). I have seen examples of this been tested, ie: a procedure which took longer than 10 seconds to execute was not cancelled when the parameter was set to 10 secs. My thinking here the thread was not IDLE but RUNNING...so this leads to the question, when does HANA deem it necessary to change the state to IDLE, is there default time when it says "ok, I gotta change this to IDLE"?

Any clarification here would be greatly appreciated.

BR
Michael

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Michael Healy
Jun 30, 2017 at 07:09 AM
0

Answer got below:

This parameter is only taken into affect when an executed SQL is blocking the Garbage Collection in a HANA DB. It not only covers IDLE statements but also ACTIVE statements, but again, only if this active statement is blocking the GC.

Still need to know when the ACTIVE statement is changed to IDLE?

Share
10 |10000 characters needed characters left characters exceeded