Another Question regarding DBC.AMPUSAGE

Analytics
Enthusiast

Another Question regarding DBC.AMPUSAGE

When usage is logged in AMPUSAGE, and we include the &D&H in the Account name, does the CPU and Disk IO get logged against multiple Days and Hours if the same unit of work spans that far?

IE if I run a query that runs for 7 hours at 9 am, does it log an entry just for the 09070209 or 7 entries showing the CPU and disk io for those hours?

Random
1 REPLY
Senior Apprentice

Re: Another Question regarding DBC.AMPUSAGE

The account string is expanded once when a query starts.
So it's just one row with the start date/hour and accumulated cpu/io.

Dieter