Sessions used by load utilties

Database
N/A

Sessions used by load utilties

We are on teradata 14.10.

Is there any query to find out number of sessions used by Load Utilities (Fastload, Multiload, TPTUpdate, Load) by looking at the DBQLOGTBL?

Thanks in advance

1 REPLY
Teradata Employee

Re: Sessions used by load utilties

Not by looking at DBQLogTbl / QryLogV alone (even in later releases). In TD15.0 and later you can optionally collect that information in DBQLUtilityTbl / QryLogUtilityV. In prior releases you would need to look at LogOnOffV (EventLog) to see how many sessions log on with the same LSN.