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

1206 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TRACKING_STATUS This represents bitmask as an integer value which
represents missing or untrusted state of fabric
members, ISLs, SANConnections, device Nodes and
device ports. 1 is missing switch/ISL in fabric, 2 is
untrusted switch or ISL in fabric, 4 is missing initiator
or port in fabric, 8 is untrusted initiator or port in
fabric, 16 is missing target or port in fabric, 32 is
untrusted target or port in fabric.
int
BOTTLENECK_STATUS Holds bottleneck status of fabric. Default is 0, Values
are 0 or 1.
int
VCS_LICENSED Indicates whether the fabric has VCS license or not.
Possible values are 0 for not applicable, 1 for licensed,
2 for not licensed. 0 is default. Fabrics representing
clusters with 2 or less nodes will have value of 0 as all
those are automatically licensed. Fabrics representing
clusters with 3 or more nodes will have values 1 or 2
depending on whether the license was acquired or
not.
int
TABLE 109 FABRIC_CHECKSUM
Field Definition Format Size
FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int
CHECKSUM_KEY * Type of checksum, e.g. device data or zone data. varchar 32
CHECKSUM Actual checksum value. varchar 16
TABLE 110 FABRIC_COLLECTION
Field Definition Format Size
FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int
COLLECTOR_NAME * Name of the collector, e.g., NameServerInfoCollector,
TopologyCollector, ZoneInfoCollector,
ActiveZoneInfoCollector.
varchar 256
SEED_SWITCH_IP IP address of the switch which serves as the seed
switch. This is the switch from which above mentioned
fabric level collectors get their information.
varchar 128
LAST_SEED_SW_
MODIFICATION
Timestamp of the seed switch, when the particular
HTML page was changed last. Note that this is not
when the last time collection was done.
timestamp
TABLE 111 FABRIC_MEMBER
Field Definition Format Size
FABRIC_ID* Fabric ID, foreign key to FABRIC table. int
VIRTUAL_SWITCH_ID* ID of the virtual switch which is a member of this fabric,
foreign key to VIRTUAL_SWITCH table.
int
TABLE 108 FABRIC (Continued)
Field Definition Format Size