Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2012 @ 20:04:34 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Session in responding state
From:   Bodla, Sravan Kumar

Hi Forum,

When COGNOS is running queries, we see the sessions in responding state for around 2-3 minutes. (The queries are shown in Active state for few seconds and then seen in responding state for longtime).

Whereas, when the same queries, when executed in the SQLA, we are able to get the results in seconds.

I understand, the DB is able to run the query in good time, but, is that the cognos is not able to pull the data faster and hence the queries are in responding state?

Can you also let me know how to find the amount of time a session(query) is in responding state from DBQL.



EMEA ? Technical Consultant

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020