Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2238)

Brocade Network Advisor SAN + IP User Manual 2201
53-1002949-01
Database tables and fields
I
TARGET_ID Target ID of the PM collector data. For device level
collector it will use deviceId/virtualSwitchId, for port
level it will use interfaceId/switchPortId/
fcipTunnelId/devicePortId. int
COLLECTOR_ID DB ID of the pm_data_collector. int
MEASURE_INDEX Stores the index_map value in case of an expression. varchar 256
ME_ID ME_ID of the target. int
VALUE Stores the 30 minutes aggregated data. double
precision
MIN_VALUE Minimum value in raw performance statistics table
while aggregating 30 minutes of data. double
precision
MAX_VALUE Maximum value in raw performance statistics table
while aggregating 30 minutes of data. double
precision
SUM_VALUE Named after SUM_VALUE to be consistent with
column names in aggregated data tables.Stores the
delta changes for counter values between two
samples, only used for counter values, 0 for all other
types of measures. double
precision
TABLE 445 TOOL_APP
Field Definition Format Size
TOOL_MENU_TEXT* Text to be displayed for the Tool Menu. varchar 256
TOOL_ID A Tool in the TOOL_PATH table where the tools are
defined. int
PARAMETERS Default path for launching the tool. varchar 256
KEY_STROKE Short cut key stroke to the application. varchar 30
TABLE 446 TOOL_PATH
Field Definition Format Size
ID* Unique generated database identifier. int
TOOL_NAME Name of the tool. varchar 256
PATH Path of the tool where installed or available. varchar 1057
WORKING_FOLDER Working folder for that application. varchar 512
TABLE 447 TOPO_MAP_IMAGE
Field Definition Format Size
ID Unique generated database identifier. int
NAME Image name in the foo.png format varchar 256
IMAGE_OBJECT 'Image Object BLOB bytea
TABLE 444 TIME_SERIES_DATA_4_30MIN (Continued)
Field Definition Format Size