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>