Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1705

Advertising
background image

Brocade Network Advisor SAN User Manual

1653

53-1003154-01

Database tables and fields

H

STATUS

Status of the collector. 0 - disabled and 1 - enabled.
Default - 0.

smallint

TYPE

Target type of the snmp collector data. for device
level collector the target type is 0, for port level it is 1.

smallint

POLLING_INTERVAL

Time interval in seconds; indicates the frequency
with which the collector will poll the device to get the
data.

int

CREATED_TIME Collector

created

time.

timestamp

CREATE_USER_ID

The user id who has created this collector.

int

ENABLE_THRESHOLD

Widget definition created server time.

smallint

THRESHOLD

Stores the threshold value.

double
precision

REARM

Stores the rearm value.

double
precision

THRESHOLD_OP

Stores the threshold operator value.

varchar

10

REARM_OP

Stores the rearm operator value.

varchar

10

IS_REARM_ABS

Whether or not the rearm. Default - 0.

smallint

THRESHOLD_SEVERITY

The severity for the threshold event.

smallint

REARM_SEVERITY

The severity for the rearm event.

smallint

IS_SYSTEM

Indicates whether this is a system built in collector,
user cannot delete it. Default - 1.

smallint

TABLE 286

PM_MEASURE

Field

Definition

Format

Size

ID*

Unique generated database identifier.

int

DESCRIPTION

The description of the
.

varchar

64

NAME

Name of the measure.

varchar

32

TABLE 287

PM_STATS_AGING_POLICY

Field

Definition

Format

Size

ID

Auto generated unique Identifier. Primary key for the
table.

int

RAW_SAMPLE_AGE The

maximum

time

in seconds for retaining records

in the PM stats raw sample tables
(TIME_SERIES_DATA_1 or TIME_SERIES_DATA_2) in
database.

int

64

THIRTY_MIN_SAMPLE_AGE The

maximum

time in seconds for retaining records

in the PM stats 30min sample tables
(TIME_SERIES_DATA_1_30MIN and
TIME_SERIES_DATA_2_30MIN) in database.

int

TABLE 285

PM_DATA_COLLECTOR (Continued)

Field

Definition

Format

Size

Advertising