Teradata Demo version

Database
Enthusiast

Teradata Demo version

Hi,

I have installed TD demo ver. on my PC. but when i try to access tables from Databases such as Retail, Financial ,etc. i get an error msg saying "AMP DOWN: Request against nonfallback cannot be done"

How do i resolve this problem in Demo version. Do i have to install it again?

Thanks,
3 REPLIES
Enthusiast

Re: Teradata Demo version


Most likely one of your "amp disk" files got corrupted. I've noticed this happening when the computer crashes while the db is running, which results in the db files getting corrupted.

You can always copy over the amp disk files from another demo installation as a shortcut to reinstalling the entire stuff. (make sure that the src and dest db servers are shutdown before you do that)

Enthusiast

Re: Teradata Demo version

Hey Joe..i got what you are trying to say..but can you tell me in detail?
like exactly which file to copy and from where?

Thanks,
Enthusiast

Re: Teradata Demo version


in the directory (if you chose the default install paths)

C:\Program Files\NCR\Tdat\tdconfig

you will find two files (depends on the number of amps, default is two)

Amp0-Pdisk0
Amp1-Pdisk0

So you can replace them from a working TD demo system (if there's anyone around with a demo)... that normally reduces the hassle of a full re-install....(this also copies over whatever user ids and data that was there in the other demo.... so it's kind of data replication ;) )

And as i mentioned, make sure both demos dbs are shutdown when you copy over them.