All Forums Database
Koentje 23 posts Joined 09/04
12 Dec 2008
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?

dnoeth 4628 posts Joined 11/04
12 Dec 2008

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.htmDieter

Dieter

Koentje 23 posts Joined 09/04
13 Dec 2008

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

omng392 8 posts Joined 06/12
30 May 2013

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

dnoeth 4628 posts Joined 11/04
02 Jun 2013

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

Dieter

You must sign in to leave a comment.