Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 Feb 2004 @ 20:54:57 GMT

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

Subj:   Re: AMP - Down Unable to Fetch the Rows
From:   Henne, Larry


If you are using the demo version of Teradata, then try the following:

Start the Teradata Database Window via "Start>>Programs>>Teradata Database>>Database Window"
Click on the "Supvr" button
In the Supervisor window enter "start vprocmanager"
In the vprocmanager window enter "status"
The display might indicate that 1 AMP vproc is in the "fatal" state
If vproc number 0 is fatal, then enter "set 0 online"
If vproc number 1 is fatal, then enter "set 1 online"
(Enter "help set" to learn more about the set command)
Exit vprocmanger by entering "quit"
Restart Teradata by entering "restart tpa nodump comment" in the Supvr window
("comment" is text that describes the reason for the restart)

Larry Henne

  <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