ALERT LIST ALL Command | unityadmin | Teradata Unity - 17.00 - ALERT LIST ALL - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

Purpose

Lists all raised and cleared alerts for the Unity server.

Syntax

ALERT LIST ALL [NORMAL | WARNING | CRITICAL];

Example

unityadmin> ALERT LIST ALL;
----------------------------------------------
The following alerts satisfy your request
----------------------------------------------
Alert No.          : 1
Alert Code         : 40001
Alert Description  : Unity sequencer has started
Alert Details      : Unity Sequencer started
Resource Type      : SEQUENCER
Resource ID        : cressida
Alert Severity     : Normal
Alert State        : Opened
Repeated           : 0
Raised Time        : 09/20 10:54:15
Updated Time       : 12/08 11:18:09
----------------------------------------------
Alert No.          : 12
Alert Code         : 40046
Alert Description  : Unity does not recognize one or more objects used in this request.                                                                                                                     
Alert Details      : Dictionary lookup failure: Database object 'lod008_e2' not                                                                                                                                found in Unity dictionary for database 'TPTLOAD' (' DROP TABLE LOD008_e2;  ')
Alert Category     : Database Operations
Resource Type      : Data_Dictionary
Resource ID        : cressida
Alert Severity     : Warning
Alert State        : Closed
Repeated           : 0
Raised Time        : 01/25 04:54:12
Updated Time       : 02/08 11:18:09
----------------------------------------------
unityadmin> ALERT LIST ALL CRITICAL;
---------------------------------------------
The following alerts satisfy your request
---------------------------------------------
Alert No.: 21
Alert Type: 40033
Alert Description: A recovery operation on an object has been interrupted. Recovery can continue when the current condition is resolved. Refer to the Teradata Unity User Guide for more information.
Alert Details: System 2 (db2) sent an inconsistent message, table: dbtest.gs114892_a, session: 1000 are interrupted:
Transaction: 7
SQL To Unity: Unspecified / No
Expected response [success] row count 0
Code: 0
Message: Success
Actual response: row count 0
Code: 3803
Message: Table 'GS114892_a' already exists.

Alert Category: Consistency
Resource Type: Data_Sync
Resource ID: unity1
Alert Severity: Critical
Alert State: Raised
Repeated: 0
Raised Time: 03/27 09:59:06
Updated Time: 03/27 09:59:06
unityadmin>