AMP Down

Database

AMP Down


I got error message when I did select a table.
Cause: [NCR] [Teradata DBMS] : AMP Down: the request against nonfallback c_m10 cannot be done.
What does it mean?

thanks,
Paul.

5 REPLIES
Enthusiast

Re: AMP Down

The message implies that there are certain Vprocs(AMP) which are not operational when you submitted the request.The data in a table is distributed in all AMPs based on the primary Index.When an all AMP request is submitted, all AMPs are involved in fetching the data.In certain conditions(like yours) when some AMPs are down /inoperational due to some reason and when the table is not fallback protected, you will get this kind of error.

I suggest you to contact systems administrator or support professional to get back all AMPs to work.

Re: AMP Down


Thanks for the info Leo Issac.
Do you think it is better to set tables as 'fallback' attribut?
thanks.
Enthusiast

Re: AMP Down

This is a design consideration: data protection vs performance.

Re: AMP Down

Hi am getting this error on TDE 14, AMP Down: the request against nonfallback DIM_DATE cannot be done. Any one can help me solve this issue.

Thanks for Advance

Re: AMP Down

i am using teradata in my local system.when i am selceting some quries i am also getting same error .how can i slove this error.please help me