Archives of the TeradataForum

Message Posted: Tue, 21 Aug 2012 @ 16:05:09 GMT

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

You can use the PMPC Open API UDFs, e.g.:

     SELECT vc.* FROM TABLE (MonitorVirtualConfig()) AS vc
     WHERE vc.VProcType='AMP' AND vc.Status='D';

     SELECT pc.* FROM TABLE (MonitorPhysicalConfig()) AS pc
     WHERE pc.Status <> 'U';  /* For nodes, as opposed to AMPs */

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