Prodreadysum and sw_event_log

Database
Kks
Enthusiast

Prodreadysum and sw_event_log

I am using V2R6.2 and discovered that there is no value coming in Resusage table column procreadysum
and also nothing sw_event_log table

I am not sure smething needs to be enable to get values in them , or it is a bug

requesting your experienced inputs

3 REPLIES
Teradata Employee

Re: Prodreadysum and sw_event_log

Are you running Teradata on Windows? ProcReadySum is only available on MP-RAS, and then only if you have ResUsage collection and logging active including table SPMA. Similarly SW_Event_Log is not used on Windows; relevant messages are written to the Windows "Application Log" instead.
Kks
Enthusiast

Re: Prodreadysum and sw_event_log

Thanks for reply ,

I am running on Linux NCR Node model 5500H
and resusage tables enabled , and other columns are populated

Teradata Employee

Re: Prodreadysum and sw_event_log

DBC.ResUsageSPMA.ProcReadySum is not populated on Linux or Windows (under any release), only MP-RAS.

DBC.SW_Event_Log is not populated on Linux or Windows prior to TD12.0.
For V2R6.2 on Linux you need to check /var/log/messages