Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: What makes an AMP go Down
From:   Pluebell, Fred

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020