Archives of the TeradataForum
Message Posted: Thu, 29 May 2003 @ 18:27:33 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|