Database Schema

 

The following sections describe the database table definitions that Log Central uses to store messages and message definitions.This information can help you determine which database tables to back up and when to back them up.

IL_MSG: Message Definition

IL_REP_MODE: Logging Level Definitions

IL_SEV: Severity Level Definitions

IL_SUBS: Subsystem Definitions

IL_SM_LOG_TABLE: Message Header Definition

IL_TRAP_CLASS: Trap Classes

IL_USER: User Data

 

---

IL_MSG: Message Definition

The following table describes the fields in the IL_MSG database table. For more information about message definitions, see:

• Creating Message Definitions.

• Message Definition in Log Central Message and Message Definition Formats.

• "Changing Message Definitions," in the Log Central Online Help.

  Table E-1 IL_MSG

  Field	Null?	Type	Size	Description
  LOG_SUBS_NAME	Not null	CHAR	8	Subsystem. See IL_SUBS: Subsystem Definitions.
  LOG_MSG_ID	Not null	NUMBER	5	Message ID.
  LOG_SDESC	Not null	CHAR	40	Summary of the description field, which is in LOG_MSG_DESC_REC.
  LOG_MSG_SEVERITY	Not null	NUMBER	1	Severity level. See IL_SEV: Severity Level Definitions.
  LOG_REP_MODE	Not null	CHAR	1	Logging level. See IL_REP_MODE: Logging Level Definitions.
  LOG_MSG_VERSION	Not null	NUMBER	3	Message version number.
  LOG_MSG_MNEMONIC	Null OK	CHAR	40	Name correlating a message to the software module that defines it.
  LOG_MSG_PARSE_FNC	Null OK	CHAR	40	Path to a script or executable file that the Central Collector runs when it stores the message in the Log Central database.
  LOG_MSG_TRAP_ID	Null OK	NUMBER	6	ID number for the SNMP trap.
  LOG_MSG_TRAP_ENABLED	Null OK	NUMBER	1	SNMP trap flag. See IL_TRAP_CLASS: Trap Classes.
  LOG_MSG_AUTO_ACK	Not null	NUMBER	1	Flag that indicates whether or not to automatically acknowledge the message.
  LOG_MSG_DESC_REC	Not null	LONG		Description and recommendation in the following format: 5 digits representing the length of the description Description Recommendation, which occupies the rest of the field

 

---

IL_REP_MODE: Logging Level Definitions

Table E-2 IL_REP_MODE

Field	Null?	Type	Size	Description
LOG_REP_MODE_ID	Not null	CHAR	1	Logging level. Possible values: N, D, V, S.
LOG_REP_MODE_DESC	Not null	CHAR	7	String that describes the logging level. Possible values: Normal, Debug, Verbose, Special.

 

---

IL_SEV: Severity Level Definitions

The following table describes the fields in the IL_SEV database table.

Table E-3 IL_SEV

Field	Null?	Type	Size	Description
LOG_SEV_ID	Not null	NUMBER	1	Severity level. Possible values: 1, 2, 3, 4, 5.
LOG_SEV_DESC	Not null	CHAR	13	String that describes the severity level. Possible values: Informational, Warning, Minor, Major, Critical.
LOG_SEV_TRAP_ID	Not null	NUMBER	1	ID number for the SNMP trap, based on message severity. Possible values: Any 6-digit number.
LOG_SEV_TRAP_ENABLED	Not null	NUMBER	1	SNMP trap flag, based on message severity. Possible values: 0, 1.

 

---

IL_SUBS: Subsystem Definitions

The following table describes the fields in the IL_SUBS database table.

Table E-4 IL_SUBS

Field	Null?	Type	Size	Description
LOG_SUBS_NAME	Not null	CHAR	8	Subsystem name.
LOG_SUBS_DESC	Null OK	CHAR	40	String that describes the subsystem name.

 

---

IL_SM_LOG_TABLE: Message Header Definition

The following table describes the fields in the IL_SM_LOG_TABLE database table. For more information about the message format, see Message Header in Log Central Message and Message Definition Formats.

Table E-5 IL_SM_LOG TABLE

Field Name	Null?	Type	Size	Description
MSG_KEY_TS	Not null	DATE		Time stamp indicating when the message was logged.
MSG_KEY_CTR	Not null	NUMBER	3	Counter for multiple messages received in the same second.
MSG_LOG_ID	Null OK	CHAR	3	Log ID.
MSG_REP_MODE	Not null	CHAR	1	Logging level. See IL_REP_MODE: Logging Level Definitions.
MSG_SEVERITY	Not null	NUMBER	1	Severity level. See IL_SEV: Severity Level Definitions.
MSG_SS_NAME	Not null	CHAR	8	Subsystem name. IL_SUBS: Subsystem Definitions.
MSG_ID	Not null	NUMBER	5	Message ID.
MSG_HOST_NAME	Not null	CHAR	64	Name of the sending host. This value can include dots, underscores, and dashes.
MSG_PID	Not null	NUMBER	5	Process ID.
MSG_UID	Not null	CHAR	8	User ID.
MSG_FCT_NAME	Null OK	CHAR	40	Name of the function.
MSG_TRAN_KEY	Null OK	CHAR	21	Entity.
MSG_VERSION	Not null	NUMBER	3	Message body version number. This is a reserved field.
MSG_TEXT	Null OK	LONG	2000	Message body.

 

---

IL_TRAP_CLASS: Trap Classes

The following table describes the fields in the IL_TRAP_CLASS database table.

Table E-6 IL_TRAP_CLASS

Field Name	Null?	Type	Size	Description
LOG_TRAP_CLASS_NAME	Not null	CHAR	16	Name of the SNMP trap class. Possible values: message, severity.
LOG_TRAP_CLASS_ENABLED	Not null	NUMBER	1	Flag that indicates whether or not to enable SNMP traps in the specified class. Possible values: 0 and 1.

 

---

IL_USER: User Data

The following table describes the fields in the IL_USER database table.

Table E-7 IL_USER TABLE

Field Name	Null?	Type	Size	Description
USERNAME	Not null	CHAR	10	User name.
PASSWORD	Not null	CHAR	10	Password.
FIELDS	Null OK	CHAR	100	List of fields to display for this user in the Message Browser. For information about the Message Browser, see the Log Central Online Help.
ORDERS	Null OK	CHAR	100	Order in which to display the fields for this user in the Message Browser. For information about the Message Browser, see the Log Central Online Help.

 

Copyright © 2000 BEA Systems, Inc. All rights reserved. Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.