AMP is down

Database

AMP is down

I have Teradata Express 13 database installed on my local machine. During a deletion from table activity running, my laptop got shutdown due to no charge. After restarting I am unable to get the database online again.

pdestate -a

PDE state is RUN/STARTED.
DBS state is 9/1: Config is not op - Unable to select an appropriate control AMP

Input Supervisor Command: get config

SYSTEM NAME: localhost 11/05/25 15:25:35

DBS LOGICAL CONFIGURATION
-------------------------

Rcv
Jrnl/
Vproc Rel. Node Can Crash Vproc Config Config Cluster/ Host VSS
Number Vproc# ID Move Count State Status Type Host No. Type Vproc
------ ------ ------ ----- ----- ------- -------- ------ -------- ----- -----
0* 1 1-01 Yes 0 FATAL Online AMP 0 On 10238
1 2 1-01 Yes 0 ONLINE Down AMP 0 On 10237
8192 4 1-01 No 0 ONLINE N/A GTW 1 COP N/A
10237 5 1-01 Yes 0 ONLINE N/A VSS 0 N/A N/A
10238 6 1-01 Yes 0 ONLINE N/A VSS 0 N/A N/A
16383 3 1-01 Yes 0 ONLINE Online PE 1 COP N/A
--------------------------------------------------------------------------------
* DBS Control AMP

DBS State: Configuration is not operational -
Unable to select an appropriate control AMP

DBS RestartKind: COLD

PDE PHYSICAL CONFIGURATION
--------------------------

Node Node Clique Memory
ID State Number CPUs (MB) CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- ---------------------------
1-01 ONLINE 0 2 2037 0 1 1 localhost
------------------------------------------------------------------------------

PDE State: RUN/STARTED

Can anyone guide how to get the database online again?
Tags (4)