User's Manual

1500 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
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 280 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 281 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 279 PM_DATA_COLLECTOR (Continued)
Field Definition Format Size