SQL Scratchpad sessions remain in responding state

Viewpoint

SQL Scratchpad sessions remain in responding state

Our business users just started using the SQL Scratchpad in Viewpoint for their adhoc queries and I've noticed that their sessions remain in the responding state after they run a query. I am not sure why they don't go to the idle state but since they are in responding they never go away. Has anyone else run into this situation?

Thanks in advance for any help.

3 REPLIES
Teradata Employee

Re: SQL Scratchpad sessions remain in responding state

The request would stay in responding state when the result set contains more than one page of data.  This allows the user to access subsequent pages of data without having to execute the query again.

Enthusiast

Re: SQL Scratchpad sessions remain in responding state

Me too in similar dilemma..Its not going away and stays back in RESPONDING state!!

Pls. help..

Appreciate your valuable Inputs.

zby
Enthusiast

Re: SQL Scratchpad sessions remain in responding state

We have the similar problem in different SW, which uses Teradata JDBC v.14