Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 May 2003 @ 18:27:33 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Query In Dispatch without visible SQL
 
From:   McBride, Michael

Does anyone know what it means to have a long running query (nearly 5 hours now) that is in a state of "ACTIVE" / Dispatch mode, but cannot display SQL text from either PMON or Session Information (with Teradata Manager) - The sql button is grayed out and unavailable. The cpu and io usage are climbing, however SPOOL has remained stagnate (unchanged) for several hours and Recovery Manager does not indicate any rollback in progress.

The query is a very basic Insert / Select statement...

insert into aeo_prodstat.ACCTG_STAT2
(
       session_nu
,      request_dt
,      request_nu
,      user_nm
,      cpu_qn
,      io_qn
)
SELECT
    e.sessionno                            (INTEGER)
,   e.logondate                              (DATE)
,   substr(a.accountname, 22,9)   (INTEGER)
,   a.username
,   sum(a.cputime)                          (FLOAT)
,   sum(a.diskIO)                             (FLOAT)
from dbc.ampusage a
       ,dbc.logonoff e
where a.username = e.username
   and substr(a.accountname, 13,9) = e.sessionno
   and substr(a.accountname,   3,6) = e.logondate (format'yymmdd')
(char(6))
   and e.event = 'logon'
   AND e.logondate > '2003-04-28' (date,format'YYYY-MM-DD')
   AND e.logondate < (current_date)
   and  substr(a.accountname,   3,2) = '03'
group by 1,2,3,4;

??? Any ideas or thoughts would be appreciated!

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters



     
  <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