Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1268 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
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 242 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 243 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
TWO_HOUR_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats 2hour sample tables
(TIME_SERIES_DATA_1_2HOUR and
TIME_SERIES_DATA_2_2HOUR) in database.
int
TABLE 241 PM_DATA_COLLECTOR (Continued)
Field Definition Format Size