Tablesize in GB

Database
Enthusiast

Tablesize in GB

Hi All,

I am using the below query to calculate the tablesize in GB. I am seeing multiple entries for the same table with various vproc.

This is the final Mart table and the same table has staging table as well. Both staging and mart table has same record count.

My question is:

1) I am seeing different row count in DBC.Tablesize for staging and mart table. For ex: staging has 75 records, mart has 115 records.

2) CurrentPerm value is same for all the records in staging table but CurrentPerm value is different for mart table. Just wanted to know how the CurrentPerm is getting calculated and the tablesize calculation in GB as per the below query is correct or not?

SEL

Tablename,

SUM(CURRENTPERM)/1024/1024/1024 AS MAX_PERM_GB

FROM DBC.Tablesize

WHERE Tablename IN ('EMPLOYEE') AND Databasename='MART'

GROUP BY 1;

3 REPLIES
Enthusiast

Re: Tablesize in GB

The question is a bit confusing ----For ex: staging has 75 records, mart has 115 records.

The table structures are the same? because sometimes staging cannot be same as target.

Enthusiast

Re: Tablesize in GB

Hi Raja,

I am talking about the records in Tablesize table. Staging and Target table has more or less same table structure but few other processing happens in target table by doing look up with some reference tables. Is that clear?

Junior Contributor

Re: Tablesize in GB

The number of rows in the dbc.DatabaseSpace table should be exactly the same (= number of AMPs in the system) for each and every table on a system. There's at least a table header on each AMP.