![]() |
![]() |
[ Bottom of Page | Previous Page | Next Page | Contents | Index ]
Before reading this section, read about the generic schema for the central data warehouse, which is described in Enabling an Application for Tivoli(R) Data Warehouse. That document defines the content of each table and explains the relationships between the tables in this document.
Shaded columns in the following tables are translated. These columns are also marked with an asterisk (*) after the column name.
This section provides a sample scenario of how information about Tivoli Enterprise Console(R) events is stored in Tivoli Data Warehouse. The event information in this chapter is based on the following scenario:
Table 10 provides the event information that was generated in step 1.
Event | Table or view | Column value |
---|---|---|
Event 1 | TEC_T_EVT_REP |
CLASS - TEC_Start DATE_RECEPTION - 1075915924 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SEVERITY - 20 STATUS - 0 LAST_MODIFIED_TIME - Feb. 4, 2004 11:32:04 AM SOURCE - TEC HOSTNAME - TECServer REPEAT_COUNT - 0 DATE_EVENT - Feb 04 11:32:04 2004 MSG - TEC Event Server Initialized MSG_INDEX - 0 NUM_ACTIONS - 0 CREDIBILITY - 1 ACL-[admin] CAUSE_DATE_RECEPTION - 0 CAUSE_EVENT_HANDLE - 0 |
TEC_T_SEVERITY |
10 - UNKNOWN 20 - HARMLESS 30 - WARNING 40 - MINOR 50 - CRITICAL 60 - FATAL |
|
TEC_T_STATUS_EVENT |
0 - OPEN 10 - RESPONSE 20 - ACK 30 - CLOSED |
|
Event 2 | TEC_T_EVT_REP |
CLASS - TEC_DB DATE_RECEPTION - 1075915941 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SEVERITY - 50 STATUS - 0 LAST_MODIFIED_TIME - Feb. 4, 2004 11:32:21 AM SOURCE - TEC REPEAT_COUNT - 0 DATE_EVENT - Feb 04 11:32:21 2004 MSG - 654 Insertion into the task repository failed - sqlcode:, sql code = -1 MSG_INDEX - 0 NUM_ACTIONS - 0 CREDIBILITY - 1 ACL-[admin] CAUSE_DATE_RECEPTION - 0 CAUSE_EVENT_HANDLE - 0 |
TEC_T_SLOTS_EVT |
DATE_RECEPTION - 1075915941 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SLOT_NAME - sql_code SHORT_SLOT_VALUE - -1 LONG_SLOT_VALUE - NULL |
|
TEC_T_SEVERITY |
10 - UNKNOWN 20 - HARMLESS 30 - WARNING 40 - MINOR 50 - CRITICAL 60 - FATAL |
|
TEC_T_STATUS_EVENT |
0 - OPEN 10 - RESPONSE 20 - ACK 30 - CLOSED |
|
Event 3 | TEC_T_EVT_REP |
CLASS - TEC_Notice DATE_RECEPTION - 1075915942 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SEVERITY - 30 STATUS - 0 LAST_MODIFIED_TIME - Feb. 4, 2004 11:32:22 AM SOURCE - TEC REPEAT_COUNT - 0 DATE_EVENT - Feb 04 11:32:22 2004 MSG_INDEX - 0 NUM_ACTIONS - 0 CREDIBILITY - 1 ACL-[admin] CAUSE_DATE_RECEPTION - 1075915941 CAUSE_EVENT_HANDLE - 1 |
TEC_T_SEVERITY |
10 - UNKNOWN 20 - HARMLESS 30 - WARNING 40 - MINOR 50 - CRITICAL 60 - FATAL |
|
TEC_T_STATUS_EVENT |
0 - OPEN 10 - RESPONSE 20 - ACK 30 - CLOSED |
The next group of events provides an example of how updated events are moved into Tivoli Data Warehouse for steps 2 through 6.
There are two classifications of updated events:
The event information in Table 11 provides an example of both types of updates to the original events. The entire event is listed, however, only the highlighted fields have been modified.
Event | Table or view | Column value |
---|---|---|
Event 1 | TEC_T_EVT_REP |
CLASS - TEC_Start DATE_RECEPTION - 1075915924 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SEVERITY - 20 STATUS - 30 LAST_MODIFIED_TIME - Feb. 4, 2004 11:35:05 AM SOURCE - TEC HOSTNAME - TECServer REPEAT_COUNT - 0 DATE_EVENT - Feb 04 11:32:04 2004 MSG - TEC Event Server Initialized MSG_INDEX - 0 NUM_ACTIONS - 0 CREDIBILITY - 1 ACL-[admin] CAUSE_DATE_RECEPTION - 0 CAUSE_EVENT_HANDLE - 0 DURATION - 181 |
TEC_T_SEVERITY |
10 - UNKNOWN 20 - HARMLESS 30 - WARNING 40 - MINOR 50 - CRITICAL 60 - FATAL |
|
TEC_T_STATUS_EVENT |
0 - OPEN 10 - RESPONSE 20 - ACK 30 - CLOSED |
|
Event 3 | TEC_T_EVT_REP |
CLASS - TEC_Notice DATE_RECEPTION - 1075915942 SERVER_HANDLE - 1 EVENT_HANDLE - 1 SEVERITY - 30 STATUS - 0 LAST_MODIFIED_TIME - Feb. 4, 2004 11:36:56 AM SOURCE - TEC REPEAT_COUNT - 2 DATE_EVENT - Feb 04 11:32:22 2004 MSG_INDEX - 0 NUM_ACTIONS - 0 CREDIBILITY - 1 ACL-[admin] CAUSE_DATE_RECEPTION - 1075915941 CAUSE_EVENT_HANDLE - 1 |
TEC_T_SEVERITY |
10 - UNKNOWN 20 - HARMLESS 30 - WARNING 40 - MINOR 50 - CRITICAL 60 - FATAL |
|
TEC_T_STATUS_EVENT |
0 - OPEN 10 - RESPONSE 20 - ACK 30 - CLOSED |
The following sections describe the component configuration.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The following sections describe the component measurement.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
TmSum_Cd | TmSum_Nm * |
---|---|
* This column is translated | |
P | Point |
MSrc_Cd | MSrc_Parent_Cd | MSrc_Nm |
---|---|---|
Tivoli | NULL | Tivoli Application |
EVENTS | NULL | Events |
EC2 | Tivoli | Tivoli Enterprise Console |
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The following section describes the component events.
EGrp_Cd | EGrpTyp_Cd | EGrp_Parent_Cd | EGrp_Nm * |
---|---|---|---|
* This column is translated | |||
EC2EVT | TIVOLI | NULL | Contains Tivoli Enterprise Console events |
EGrp_Cd | EGrpTyp_Cd | EventTyp_ID |
---|---|---|
EC2EVT | TIVOLI | 1 |
EC2EVT | TIVOLI | 2 |
EC2EVT | TIVOLI | 3 |
EC2EVT | TIVOLI | 4 |
EC2EVT | TIVOLI | 5 |
EGrpTyp_Cd | EGrpTyp_Nm * |
---|---|
* This column is translated | |
TIVOLI | Event Group for Tivoli Products |
The Tivoli Enterprise Console warehouse pack does not use this table.
EventReln_ID | Event_Source_ID | Event_Target_ID | RelnTyp_Cd | MSrc_Cd |
---|---|---|---|---|
1 | 2 | 3 | CAUSES | EC2 |
2 | 5 | 1 | UPDATE | EC2 |
3 | 4 | 3 | UPDATE | EC2 |
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use this table.
The Tivoli Enterprise Console warehouse pack does not use helper tables.
The Tivoli Enterprise Console warehouse pack does not use exception tables.
The Tivoli Enterprise Console warehouse pack supports incremental extraction. For more information about incremental extraction, see Extraction control (table Extract_Control).
[ Top of Page | Previous Page | Next Page | Contents | Index ]