Idle sessions are blocking other Teradata jobs. This is happening with only my userid. When I ran a query against a table , i got the result in 2 seconds. However the session was idle there after.
A production job (which has some sql on the same table) was beign blocked by my the sql which I ran earlier.
Following is the status when I clicked on "Blocked By" button on teradata manager. Host ID:1 Session ID:... User:.. Status: Granted Mode: Read Type: Table
The DBA's had to kill my session , for the Job to complete
Is there a way we can set up aborting of idle sessions from Teradata ? e.g., let's say I want all the idle sessions/connections from Teradata database to terminate after they have remained inactive for 1 mins. Is there a way to do it ?
Is there any setting on the TD SQL Assistant itself.