Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

Brocade Network Advisor Documentation Updates 57
53-1002363-02
Database tables and fields
E
LATENCY double precision
BANDWIDTH double precision
TABLE 87 ISL
Field Definition Format Size
ID* int
FABRIC_ID Fabric DB ID. int
SOURCE_DOMAIN_ID Source domain ID. int
SOURCE_PORT_NUMBER Source port number. smallint
DEST_DOMAIN_ID Destination domain ID. int
DEST_PORT_NUMBER Destination port number. smallint
COST The cost of the link. int
TYPE The type of link. smallint
TRUSTED 1 = ISL is trusted
0 = ISL is not trusted
Default value is 0.
smallint
CREATION_TIME Time at which this record was created.
Default value is ’now()’.
timestamp
MISSING 1 = ISL is missing
0 = ISL is not missing
Default value is 0.
smallint
MISSING_TIME Time at which ISL went missing. timestamp
TABLE 88 FABRIC
Field Definition Format Size
ID* int
SAN_ID Foreign key to SAN table; usually 1 since there is only
one SAN.
int
SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to
discover the fabric.
char 23
NAME User-assigned fabric name. varchar 256
CONTACT User-assigned "contact" for the fabric. varchar 256
LOCATION User-assigned "location" for the fabric. varchar 256
DESCRIPTION User-assigned fabric description. varchar 256
TYPE Type of fabric:
0 = legacy fabric
1 = base fabric
2 = logical fabric
smallint
SECURE 1 = it is a secured fabric. smallint
AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric. smallint
TABLE 84 GIGE_PORT_STATS_1DAY (Continued)
Field Definition Format Size