Archives of the TeradataForum
Message Posted: Thu, 03 Mar 2016 @ 10:17:45 GMT
<-- Anonymously Posted: Thursday, March 03, 2016 12:40 -->
Is there any query to find out how many sessions are used by each load job?
I am using the following query :
SEL acctstringdate,appid,UserName,lsn,min(collecttimestamp) as mini,MAX(collecttimestamp) as maxi, (( maxi-mini) hour(4) to second) as duration,COUNT(*) as session_cnt FROM dbc.dbqlogtbl WHERE appid in ('FASTLOAD','MULTLOAD','TPTLOAD','TPTUPD') group by 1,2,3,4 order by maxi desc;
Is above query accurate?
Thanks in advance !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|