Archives of the TeradataForum
Message Posted: Thu, 16 Mar 2006 @ 22:36:00 GMT
Subj: | | Re: Identifying Large NUSI ? |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, March 16, 2006 17:15 -->
"It will not give NUSI size ... only identifies size of tables that have NUSI's"
Yes Lisa, that's correct.
Because the currentperm information in DBC is always kept as only the sum of the space utilized in each AMP by all subtables belonging to the
table, this is due to the fact that in order to keep track of space utilization, Teradata uses only the first 32 bits from Table ID in table
DBC.DatabaseSpace (as type BYTE(4)), not considering the additional 16 bits from Table ID, which identify each specific subtable.
As others have stated, you must use ferret to know how much space belongs to each subtable.
|