IBM Tivoli Software IBM Tivoli Software

[ Bottom of Page | Previous Page | Next Page | Contents | Index ]


Central data warehouse information

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.

Sample scenario

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:

  1. The following events are generated by the Tivoli Enterprise Console: For the event information, see Table 10.
  2. An active correlation rule identified the TEC_DB event as the cause of the TEC_Notice event and correlated these two events.
  3. An operator used the Tivoli Enterprise Console to close the TEC_Start event.
  4. Two TEC_Notice events are generated by the Tivoli Enterprise Console.
  5. A duplication filter rule dropped these two events.
  6. The repeat count attribute of the TEC_Notice event was updated.

Table 10 provides the event information that was generated in step 1.

Table 10. Original Events
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.

Notes:
  1. Extraction control is based on the last_modified_time field in the event database. This warehouse pack knows that events are updated when the event already exists in Tivoli Data Warehouse and the last_modified_time field has been updated. This warehouse pack then determines which field changed, and stores the appropriate updated value if one exists.
  2. Not all base attributes are specified for the events.
Table 11. Modified Events
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

Component configuration

The following sections describe the component configuration.

Component Type

The Tivoli Enterprise Console warehouse pack does not use this table.

Component Extension

The Tivoli Enterprise Console warehouse pack does not use this table.

Component

The Tivoli Enterprise Console warehouse pack does not use this table.

Relationship Type

Table 12. Relationship Type (TWG.RelnTyp Table)
RelnTyp_
Cd
RelnTyp_Nm * MSrc_
Corr_Cd
* This column is translated
CAUSES This represents a generic relationship where an entity causes another entity. MODEL1
UPDATE This represents a relationship where one entity updates another entity. EVENTS

Relationship Rule

The Tivoli Enterprise Console warehouse pack does not use this table.

Component Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Component Type Keyword

The Tivoli Enterprise Console warehouse pack does not use this table.

Attribute Type

The Tivoli Enterprise Console warehouse pack does not use this table.

Attribute Rule

The Tivoli Enterprise Console warehouse pack does not use this table.

Attribute Domain

The Tivoli Enterprise Console warehouse pack does not use this table.

Component Attribute

The Tivoli Enterprise Console warehouse pack does not use this table.

Component Type Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Attribute Type Relation

The Tivoli Enterprise Console warehouse pack does not use this table.

Component measurement

The following sections describe the component measurement.

Measurement Group Type

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Group

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Group Member

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Unit Category

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Unit

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Type Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Time Summary

Table 13. Time Summary (TWG.TmSum Table)
TmSum_Cd TmSum_Nm *
* This column is translated
P Point

Measurement Source

Table 14. Measurement Source (TWG.MSrc Table)
MSrc_Cd MSrc_Parent_Cd MSrc_Nm
Tivoli NULL Tivoli Application
EVENTS NULL Events
EC2 Tivoli Tivoli Enterprise Console

Measurement Source History

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Type

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement Rule

The Tivoli Enterprise Console warehouse pack does not use this table.

Measurement

The Tivoli Enterprise Console warehouse pack does not use this table.

Threshold Measurement Objective

The Tivoli Enterprise Console warehouse pack does not use this table.

Threshold Measurement Objective Range

The Tivoli Enterprise Console warehouse pack does not use this table.

Threshold Severity Level

The Tivoli Enterprise Console warehouse pack does not use this table.

Component events

The following section describes the component events.

Event Type

Table 15. Event Type (TWG.EventTyp Table)
EventTyp_ID EventTyp_Nm * MSrc_Cd EventTyp_Ds *
Notes:
  1. * This column is translated
  2. The following EventTyp_Nm values are loaded by the central data warehouse ETL when it is run, not when the Tivoli Enterprise Console is installed:
    • TEC_Start
    • TEC_Notice
    • TEC_DB
1 Attribute Update EVENTS This event represents an update to existing event attributes.
2 Repeat Count EVENTS This event represents an update to the initial Repeat_cnt in the Event Table.
3 TEC_Start EC2
4 TEC_Notice EC2
5 TEC_DB EC2

Event

Table 16. Event (TWG.Event Table)
Event
_ID
Event
Typ
_ID
Event_
DtTm
Tm
Sum_Cd
MSrc_
Cd
Repeat
_Cnt
Centr_
Cd
Cust
_ID
Event_
Corr_ID
Event_
Corr_Val
1 3 2004-02-04-17:32:04.000000 P EC2 0 CDW 1 NULL 1-1-1075915924
2 5 2004-02-04-17:32:21.000000 P EC2 0 CDW 1 NULL 1-1-1075915941
3 4 2004-02-04-17:32:22.000000 P EC2 0 CDW 1 NULL 1-1-1075915942
4 2 2004-02-04-17:35:05.000000 P EC2 2 CDW 1 NULL 1-1-1075915924
5 1 2004-02-04-17:36:56.000000 P EC2 0 CDW 1 NULL 1-1-1075915942

Event Attribute

Table 17. Event Attribute (TWG.EventAttr Table)
Event_ID EventAttr_Id EAttrTyp_Cd MSrc_Cd EventAttr_Val
1 1 EC2_ACL EC2 [admin]
1 2 EC2_CREDIBILITY EC2 1
1 3 EC2_DATE_EVENT EC2 Feb 04 11:32:04 2004
1 4 EC2_HOSTNAME EC2 TECServer
1 5 EC2_MESSAGE EC2 TEC Event Server Initialized
1 6 EC2_MESSAGE_
INDEX
EC2 0
1 7 EC2_NUMBER_OF_
ACTIONS
EC2 0
1 8 EC2_SERVER_HANDLE EC2 1
1 9 EC2_SEVERITY EC2 Harmless
1 10 EC2_SOURCE EC2 TEC
1 11 EC2_STATUS EC2 Open
2 12 EC2_ACL EC2 [admin]
2 13 EC2_CREDIBILITY EC2 1
2 14 EC2_DATE_EVENT EC2 Feb 04 11:32:21 2004
2 15 EC2_MESSAGE EC2 654 Insertion into the task repository failed - sqlcode:, sql_code = -1
2 16 EC2_MESSAGE_
INDEX
EC2 0
2 17 EC2_NUMBER_OF_
ACTIONS
EC2 0
2 18 EC2_SERVER_HANDLE EC2 1
2 19 EC2_SEVERITY EC2 Critical
2 20 EC2_SOURCE EC2 TEC
2 21 EC2_STATUS EC2 Open
2 22 EC2_exts_sql_code EC2 -1
3 23 EC2_ACL EC2 [admin]
3 24 EC2_CREDIBILITY EC2 1
3 25 EC2_DATE_EVENT EC2 Feb 04 11:32:22 2004
3 26 EC2_MESSAGE_
INDEX
EC2 0
3 27 EC2_NUMBER_OF_
ACTIONS
EC2 0
3 28 EC2_SERVER_HANDLE EC2 1
3 29 EC2_SEVERITY EC2 Warning
3 30 EC2_SOURCE EC2 TEC
3 31 EC2_STATUS EC2 Open
5 32 EC2_ADMINISTRATOR EC2 Root_TECServer-Region
5 33 EC2_DURATION EC2 181
5 34 EC2_STATUS EC2 Closed

Event Attribute Type

Table 18. Event Attribute Type (TWG.EAttrTyp Table)
EAttrTyp_Cd EAttrTyp_Nm * MSrc_Cd
* This column is translated.
** This data is not translated because it is dynamically inserted into the table.
IP_HOSTNAME Fully Qualified Hostname EVENTS
EC2_ACL Tivoli Enterprise Console Authorization Roles EC2
EC2_ADAPTER_HOST Tivoli Enterprise Console Adapter Host EC2
EC2_ADMINISTRATOR Tivoli Enterprise Console Administrator EC2
EC2_CREDIBILITY Tivoli Enterprise Console Credibility EC2
EC2_DURATION Tivoli Enterprise Console Duration EC2
EC2_DATE_EVENT Tivoli Enterprise Console Date EC2
EC2_HOSTNAME Tivoli Enterprise Console Hostname EC2
EC2_MESSAGE Tivoli Enterprise Console Message EC2
EC2_MESSAGE_CATALOG Tivoli Enterprise Console Message Catalog EC2
EC2_MESSAGE_INDEX Tivoli Enterprise Console Message Index EC2
EC2_NUMBER_OF_
ACTIONS
Tivoli Enterprise Console Number of Tracked Actions EC2
EC2_ORIGIN Tivoli Enterprise Console Origin EC2
EC2_SERVER_HANDLE Tivoli Enterprise Console Server Handle EC2
EC2_SEVERITY Tivoli Enterprise Console Severity EC2
EC2_SOURCE Tivoli Enterprise Console Source EC2
EC2_STATUS Tivoli Enterprise Console Status EC2
EC2_SUB_ORIGIN Tivoli Enterprise Console Sub Origin EC2
EC2_SUB_SOURCE Tivoli Enterprise Console Sub Source EC2
EC2_exts_sql_code sql_code ** EC2

Event Group

Table 19. Event Group (TWG.EGrp Table)
EGrp_Cd EGrpTyp_Cd EGrp_Parent_Cd EGrp_Nm *
* This column is translated
EC2EVT TIVOLI NULL Contains Tivoli Enterprise Console events

Event Group Member

Table 20. Event Group Member (TWG.EGrpMbr Table)
EGrp_Cd EGrpTyp_Cd EventTyp_ID
EC2EVT TIVOLI 1
EC2EVT TIVOLI 2
EC2EVT TIVOLI 3
EC2EVT TIVOLI 4
EC2EVT TIVOLI 5

Event Group Type

Table 21. Event Group Type (TWG.EGrpTyp Table)
EGrpTyp_Cd EGrpTyp_Nm *
* This column is translated
TIVOLI Event Group for Tivoli Products

Event Type Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Event Relationship

Table 22. Event Relationship (TWG.EventReln 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

Component-Event Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Event Rule Relationship

Table 23. Event Rule Relationship (TWG.ERelnRul Table)
ETyp_Source_ID ETyp_Target_ID RelnTyp_Cd ERul_Strt_DtTm ERul_End_DtTm
1 3 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
2 4 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
2 3 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
1 4 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
1 5 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
2 5 UPDATE 2004-02-04-16:33:05.000000 9999-01-01-00.00.00.00
5 4 CAUSES 2004-02-04-16:37:21.000000 9999-01-01-00.00.00.00

Component-Event Rule Relationship

The Tivoli Enterprise Console warehouse pack does not use this table.

Helper tables

The Tivoli Enterprise Console warehouse pack does not use helper tables.

Exception tables

The Tivoli Enterprise Console warehouse pack does not use exception tables.

Incremental extraction

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 ]