Archives of the TeradataForum
Message Posted: Wed, 23 May 2001 @ 21:48:18 GMT
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
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|