15.10 - Software_Event_LogV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

TheDate

DATE

NOT NULL

YY/MM/DD (explicit)

SW_Event_Log.TheDate (Composite NUPI)

TheTime

TIME

NOT NULL

99:99:99.999999 (explicit)

SW_Event_Log.TheTime (Composite NUPI)

Event_Tag

INTEGER

NOT NULL

Z99-99999-99 (explicit)

SW_Event_Log.Event_Tag

Category

BYTEINT

Z9 (explicit)

SW_Event_Log.Category

Severity

SMALLINT

ZZ9 (explicit)

SW_Event_Log.Severity

PMA

INTEGER

ZZ9-99 (explicit)

SW_Event_Log.PMA

Vproc

INTEGER

-(5)9 (explicit)

SW_Event_Log.Vproc

Partition

BYTEINT

Z9 (explicit)

SW_Event_Log.Partition

Task

SMALLINT

ZZZZ9 (explicit)

SW_Event_Log.Task

TheFunction

VARCHAR(32) LATIN

NOT CASESPECIFIC

X(32)

SW_Event_Log.TheFunction

SW_Version

VARCHAR(64) LATIN

NOT CASESPECIFIC

X(64)

SW_Event_Log.SW_Version

Line

BYTEINT

NOT NULL

ZZ9 (explicit)

SW_Event_Log.Line

Text

VARCHAR(30000)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(255)

SW_Event_Log.Text

Possible Values for Category

 

Value

Description

0

None

1

CPU hardware

2

Memory hardware

3

TDN hardware

4

Disk hardware

5

Channel hardware

6

Host

7

Driver

8

Resource

9

System

10

User

11

Occurrence

12

Abnormal

52

Base TP

64

Max TPSys

Possible Values for Severity

 

Value

Description

0

Hardware and software are informational events (Occurrence)

10

Software abnormality -- informational (SW abnormality)

20

Hardware abnormality -- informational (HW abnormality)

30

Recoverable user error (UserError retry)

40

Unrecoverable user error (UserError)

50

Unrecoverable user error, no user restart (UserFatal)

60

Unrecoverable Vproc error, Vproc restart required (VprocError)

70

Unrecoverable Vproc error, no Vproc restart (VprocFatal)

80

Recoverable PDE error (OSErrorRetry)

90

Unrecoverable PDE error, restart required (OSError)

100

Unrecoverable PDE error, restart not possible (OSFatal)

110

Unrecoverable CPU hardware error, restart required (CPUError)

120

Unrecoverable CPU hardware error, CPU stay down (CPUFatal)

130

Unrecoverable PMA hardware error, PMA restart required (PMAError)

140

Unrecoverable PMA hardware error, PMA stays down (PMAFatal)

200

Unrecoverable system error, system restart required (SystemError)

210

Unrecoverable System error, restart not possible (SystemFatal)

The following statement requests the software event log information for any event with a severity level of 50 (unrecoverable user error, no user restart):

SELECT TheDate, TheTime, Category, Severity
   FROM Software_Event_LogV
   Where Severity = ‘50’ ;

Result:

TheDate    ­TheTime    ­Category   ­Severity
--------   --------   --------   --------
92/08/20   10:10:30   4          50