DBC.DBQLOGTBL - WDID to WDNAME mapping

Database
Junior Supporter

DBC.DBQLOGTBL - WDID to WDNAME mapping

Hi,

Is there a query/pdcr macro using which we can take out the workload name in which a query started and finalworkload name ? We have fields wdname and finalwdname in pdcrinfo.dbqlogtbl_hst. But in DBC.DBQLOGTBL we have WDID and FinalWDID. How to map these IDs to wdname?

--samir

2 REPLIES
Teradata Employee

Re: DBC.DBQLOGTBL - WDID to WDNAME mapping

The names come from TDWM tables. Look at the logic in the LoadDBQLHstTbls macro.

Junior Supporter

Re: DBC.DBQLOGTBL - WDID to WDNAME mapping

Thanks Fred, let me check the macro !