15.00 - Startup/Restart Messages - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Startup/Restart Messages

At startup, messages are displayed to report the startup progress and the Teradata Database system status. This report includes some recovery process messages as shown below:

H005 Control AMP 001-2

98/02/06  11:35:31  Running DBS Version: 14.00.00.00
98/02/06  11:35:31  Running PDE Version: 14.00.00.00
98/02/06  11:35:32  Current DBS config maps are synchronized (Version: 11)
98/02/06  11:35:32  New DBS config maps are synchronized (Version: 11)
98/02/06  11:35:32  AMP 0000 has been selected as the Control AMP
98/02/06  11:35:33  Initializing DBS Vprocs
98/02/06  11:35:36  Configuration is operational
98/02/06  11:35:36  Starting AMP partitions
98/02/06  11:35:40  Connection accepted
98/02/06  11:36:02  Voting for transaction recovery
98/02/06  11:36:05  Recovery session 1 contains 77 rows on AMP 0000
98/02/06  11:36:16  Starting transaction recovery
98/02/06  11:36:18  Completed transaction recovery
98/02/06  11:36:18  Starting PE partitions
98/02/06  11:37:03  System is operational
98/02/06  11:37:05  Users are logged on
98/02/06  11:37:05  Logons are enabled

The following table lists and explains these and other messages.

 

Message #...

Means...

1 - AMP mmmm in cluster nnn is back online

the specified AMP which was offline is now back online.

2 - AMP mmmm is in offline catchup

the AMP is in offline catchup mode.

3 - AMP mmmm is in online catchup

the AMP is in online catchup mode.

4 - AMP mmmm not brought online for the following reason(s):

one of the following:

  • Changed row journal count of ZZ,ZZZ,ZZ9 exceeds 3000 rows.
  • At least one “long” running ordered journal record remains.
  • At least one HUT lock might exist in the cluster.
  • At least one two-phase-commit transaction is in doubt.
  • 5 - Completed transaction recovery

    Transaction Recovery for online AMPs is compete.

    6 - Recovering down AMPs

    the recovery process is updating tables on AMPs that are in offline catchup.

    Note: If there was no down AMP in catchup recovery mode, this message is not displayed.

    7 - Recovery session 1 contains 103 rows on AMP 0001
     

    that AMP 0001 has the largest number of rows in the transient journal for the given recovery session. Other AMPs probably have a similar or less rows for the same recovery session. The count reflects how many rows were in the transient journal at the time of the Teradata Database system restart. It does not necessarily mean a rollback action has to be performed for each row.

    8 - Starting transaction recovery

    transaction recovery has started on online AMPs.

    9 - Startup will wait for recovery to complete

    the user initiated a COLDWAIT restart.

    10 - Voting for transaction recovery
     

    the application software is determining if there were any incomplete transactions left from the previous operation. Voting is a process by which each AMP examines the transactions that were in process. Any uncompleted transaction will have to be rolled back.