Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 May 2001 @ 21:48:18 GMT

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

Subj:   Re: AMP/Disk Configuration
From:   Glenn McCall

I wasn't sure if you are wanting to report how much space is being used by vproc or what disk drives were being controlled by specific vprocs.

If you want to know how much space is being used by each vproc for a particular database, the DBC.allspace table contains all sorts of useful information.

A query such as

select vproc, currentperm
from dbc.allspace
where databasename = 'yourdbname' and
tablename = 'all';

should do the trick.

Alternatively, you could substitute the word all in "Tablename = 'all'" for an actual table name and see how its data is laid out across the vprocs.

Hope this helps

Glenn Mc

  <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: 15 Jun 2023