Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Jun 2002 @ 01:46:44 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Question on space utilization of a database
 
From:   Narayan Murthy K S

All,

I have a question on the space utilization of a database.

Suppose i have a database say "EmpDB" which has a single table "employee". Now this table contains say 6 rows. Suppose the defintion of the table "employee" is as follows :

Create table employee (
    empid integer,
    empfirstname char(30),
    emplastname  char(30),
    location char(40),
    doj      date);

All the fields in this table are fixed length fields.

Suppose we have a 4 amp configuration. Now using Filer i am able to get the Tableheader row length and also the row length of the rows. Now summing these values say i get a value "A". Now using a query on dbc.diskspace i get the currentpermspace used by this database "EmpDB".

I see a considerable difference between the value "A" obtained above and the value returned by the query. Why is this difference? What more needs to get into "A" which would make it equal to sum(currentpermspace) w.r.t the database "EmpDB"


Thanks

Narayan Murthy K S.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016