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

Brocade Network Advisor SAN User Manual 1269
53-1002696-01
Database tables and fields
H
ONE_DAY_SAMPLE_AGE The maximum time in seconds for retaining records
in the PM stats 1day sample tables
(TIME_SERIES_DATA_1_1DAY,
TIME_SERIES_DATA_2_1DAY) in database.
int
POLICY_TYPE Type of the aging policy. 100 is Default aging; 101 is
Raw samples to 1 day.
int
ACTIVE State of the aging policy. 1 is Active, 0 is Inactive. int 32
TABLE 244 PM_WIDGET_MEASURE_TYPE
Field Definition Format Size
Type Primary key column. int
NAME Storing the NAME of the measure. varchar 64
TABLE 245 PM_WIDGET_MONITOR_TYPE
Field Definition Format Size
Type Primary key column. int
NAME Storing the NAME of the monitor type. varchar 64
TABLE 246 PM_WIDGET_TARGET_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
TARGET_TYPE 0 - Device
1 - Port
smallint
TARGET_ID Stores device ID if taret_TYPE is Device, or interface
DB ID if target TYPE is port.
int
TABLE 247 PM_WIDGET_TIME_SERIES_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
TARGET_TYPE 0 - Device
1 - Port
smallint
TARGET_ID Stores device ID if taret_TYPE is Device, or interface
DB ID if target TYPE is port.
int
MEASURE_ID Measure table DB ID. int
MEASURE_INDEX Index value for a MIB variable. For scalar value it will
be empty.
varchar 256
TABLE 243 PM_STATS_AGING_POLICY (Continued)
Field Definition Format Size