Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.


Thanks,

Sravan.

SRAVAN KUMAR BODLA
EMEA ? Technical Consultant



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