Statistics information retrieved in dbc for Teradata 12

Database
Enthusiast

Statistics information retrieved in dbc for Teradata 12

What is the query to read the statistics information in dbc for Teradata 12?
We had something for previous releases.
Or is there no impact due to the new release on dbc level?
4 REPLIES
Junior Contributor

Re: Statistics information retrieved in dbc for Teradata 12

Hi Koen,
there changed a lot in TD12, especially on 64bit.
You'll find the latest version of that stats query on the TeradataForum:
http://www.teradataforum.com/attach.htm

Dieter
Enthusiast

Re: Statistics information retrieved in dbc for Teradata 12

This is really what I wanted to have.
Thanks a lot for this quick response.

Koen.
Teradata Employee

Re: Statistics information retrieved in dbc for Teradata 12

Gents,

Good day, we recently upgraded to a 8 or 9 node 6690 appliance and TD14, when I run the 64 bit query, I get an error on the NumValues and NumRows (expotional calculations).  With a numeric overflow. I've tried casting the each value to decimal (25,4), to float etc... without success. Now this use to run, but we did do a node expansion recently, would the additional node or TD 14 cause this issue?  Does TD 12 treat its hashbucket differently than TD14?

Thanks in Advnace

Junior Contributor

Re: Statistics information retrieved in dbc for Teradata 12

The link above is an old version of my stats query, the latest one is on DevEx now:

How to decode the binary statistics stored in dbc tables

But this is only up to TD13.10, as TD14 introduced a new way to store stats. Most of the info is now easily available in dbc.StatsV.

Dieter