Stats Log?

Database
Highlighted
Enthusiast

Stats Log?

Do you know where logs are stored or what query you can run when you refresh these with stats? (is it pdcr related?)

For example, suppose I run help stats on a particular table and I either see no stats or outdated applied stats

I want to find and trace in log to see whether stats was applied, but failed or whether stats was not applied at all, etc etc
2 REPLIES 2
Teradata Employee

Re: Stats Log?

Hi etrxnox,

 

Check in the view dbc.StatsV.

No rows for your table means no stats, and if they exists there is the timestamp of the last collection.

Teradata Employee

Re: Stats Log?

And yes, PDCR would be a logical place to look to see if (more recent) stats collection was attempted but failed.