TD Express "DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRES"

Database

TD Express "DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRES"

I'm install a TD Express 13.0 on VMware Win 2003 (32bit).

When try connect to database from bteq, I have a next error:

>bteq

 Teradata BTEQ 13.00.00.03 for WIN32.

 Copyright 1984-2009, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.logon 127.0.0.1/dbc

.logon 127.0.0.1/dbc

Password:

 *** Warning: DBS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS>

 *** Warning: Exiting because of three BREAKs!

 ***  Exiting...

>bteq

 Teradata BTEQ 13.00.00.03 for WIN32.

 Copyright 1984-2009, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.logon localhost/dbc

.logon localhost/dbc

Password:

 *** CLI error: CLI2: BADLOGON(303): Invalid logon string.

 *** Return code from CLI is: 303

 *** Error: Logon failed!

 *** Total elapsed time was 14 seconds.

 Teradata BTEQ 13.00.00.03 for WIN32. Enter your logon or BTEQ command:

.logon localtdcop1/dbc

.logon localtdcop1/dbc

Password:

 *** CLI error: CLI2: BADLOGON(303): Invalid logon string.

 *** Return code from CLI is: 303

 *** Error: Logon failed!

 *** Total elapsed time was 13 seconds.

 Teradata BTEQ 13.00.00.03 for WIN32. Enter your logon or BTEQ command:

hosts file:

127.0.0.1       localhost  localtdcop1

vprocmanager:

>status

 

SYSTEM NAME: localhost                                      11/11/20 21:23:31

 

                          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   Down      AMP       0    On    10238

    1*    2     1-01  Yes     0   FATAL   Online    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: DBS is not running

 

  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   1595    0     1    0  localhost

 

------------------------------------------------------------------------------

 

 

  PDE State: RUN/READY

 

Enter a command, HELP or QUIT:



 

Pls help me to fix it.

 

 

 

 

3 REPLIES

Re: TD Express "DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRES"

up

Re: TD Express "DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRES"

up

Re: TD Express "DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRES"

I'm try do this:

http://forums.teradata.com/forum/database/2642-amp-down-the-request-against-nonfallback-contract-can...

but have:

SYSTEM NAME: localhost                                      11/11/27 18:29:20

                          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   ONLINE  Down      AMP       0    On    10238

    1*    2     1-01  Yes     0   ONLINE  Online    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: DBS is not running

  DBS RestartKind: COLDWAIT

                          PDE PHYSICAL CONFIGURATION

                          --------------------------

Node    Node    Clique      Memory

ID      State   Number CPUs  (MB)  CHANs LANs AMPs Node Name

------- ------- ------ ---- ------ ----- ---- ---- ---------------------------

  1-01  ONLINE     0     2   1595    0     1    2  localhost                       

------------------------------------------------------------------------------

  PDE State: RUN/READY