WDID in tables?

Tools
Enthusiast

WDID in tables?

In the table DBC.TDWMsummaryLog the WDID column, is there a table I can link to to get a more meaningful description? or even more information about it?

4 REPLIES
Enthusiast

Re: WDID in tables?

Try looking at WlcName in TDWM.WlcDefs.
Enthusiast

Re: WDID in tables?

What table has replaced Wlcdefs in Teradata 13.10? I want to be able to map WDID from Querylog with the workload name so I can determine who is still coming in the default workload?

Enthusiast

Re: WDID in tables?

for 13.10 it's TDWM.Ruledefs (Ruletype=5 for Workload)

Enthusiast

Re: WDID in tables?

Starting from 13.10 PDCRDATA.Dbqloghtbl_Hst also includes Start and Final Workload name.