How to find how many mloads triggered

Database

How to find how many mloads triggered

I am looking for information on howmany mloads triggers on Teradata instance during a particular time frame like 9 am to 12pm.

Would like to see count by user, triggered time, and query ( if possible). Can you please help me if there is a way pull from DBC tables?

1 REPLY
Senior Apprentice

Re: How to find how many mloads triggered

You can check the queryband in dbc.QryLogV for UTILITYNAME=MULTLOAD, all load sessions share the same value in the LSN column.