Archives of the TeradataForum

Message Posted: Thu, 15 Jan 2009 @ 18:18:09 GMT

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

Hi Rit,

The number of Nodes on the system:

     SEL COUNT(DISTINCT(nodeid))
     FROM dbc.resgeneralinfoview;

For the type of nodes you will probably have to be ask your Teradata a/c team or someone from the account who looks after the system (Operations ?).

Time for a full table scan. Run something like the following:

     Select count(*)
      from 
     Where ACCT_ID <> 1;
     (I'm assuming ACCT_ID is a numeric value)

Regards,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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