Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1427)

1380 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
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 110 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 111 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 112 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
TRUSTED 1 = the switch is a trusted member of the fabric. Either
found in the initial discovery or user subsequently
entrusted the switch by user action.
Default Value is 0. smallint
CREATION_TIME When the switch became a member.
Default Value is ’now()’. timestamp
MISSING 1 = it is missing from the fabric.
Default Value is 0. smallint
TABLE 109 FABRIC (Continued)
Field Definition Format Size