Archives of the TeradataForum

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

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

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>>