Archives of the TeradataForum

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

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

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>>