ERROR IN AMP

Database

ERROR IN AMP

Hello my friends,

I'm having problems in my bteq when I try to insert data into a table. happens the error below:

** Failure 2642 AMP Down: the request can not TB_PESSOA against nonfallback
be done.

What should I do to solve this problem?

Thank´s for helping me
4 REPLIES
Senior Apprentice

Re: ERROR IN AMP

You lost an AMP.
If it's a demo version you might check Windows EventLog for Teradata related errors.

The easiest would be a re-install, because you already lost some data.

If it's not the demo, you should contact your support.

Dieter
Teradata Employee

Re: ERROR IN AMP

2 weeks ago, Another member had this error, I've posted the usual way to recover AMP's ( if recoverable!!).
The post title was:
"2642: Amp Down. The Request against nonfallback CONTRACT cannot be done"
you could follow the procedure and Hopfully recover your Data.
As Dieter mentioned, If IT'S NOT A DEMO, contact your Teradata Support!

Re: ERROR IN AMP

Hi All,

Loga here.

I am new to Teradata Admin part.And, am getting error "2642 AMP down: the request against fallback emp cannot be done"

For the above error code, i got solution in below link.(www.info.teradata.com)

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111...

Given solution:

If you receive an error that an AMP is down (for example from a MultiLoad or BTEQ job) use Vprocmanager to reboot a fatal AMP or bring a offline down AMP up.

Here i don't have idea how to use VProc manager to reboot a fatal AMP and don't know how to bring offline down AMP up.

Can anyone guide me how to fix this error.

Note: I am working on client and i have complete server access. Please let me know if anything to be done in server side.

-Loga

Re: ERROR IN AMP

Can anyone help on above Query... Pls...