Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Table Of Contents
1412 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
SOURCE_SWITCH_PORT_ID The Switch port ID of the Source Switch (local end of
the ISL). Maintained as a nullable foreign key to
account for ports being moved from one VF to other.
int
TARGET_SWITCH_PORT_ID The Switch port ID of the Target Switch (remote end
of the ISL). Maintained as a nullable foreign key to
account for ports being moved from one VF to other.
int
COST Cost of the ISL link. int
TYPE Type of the IS. int
TRUSTED Denotes whether ISL link is trusted or not. 0 denotes
untrusted and 1 is for trusted.
int
MISSING Denotes whether ISL link is missing or not. 0 denotes
present and 1 states that ISL is missing.
int
MISSING_TIME Missing timestamp. timestamp
CREATION_TIME Creation timestamp. timestamp
TRUNKED This column is used to determine whether the isl is
part of a trunk or not. The value of 0 means not
trunked, 1 means this isl is part of a trunk and -1
means not applicable status. Default value is -1.
int
MASTER_CONNECTION_ID This will hold the id of the master ISL connection for
a ISL between trunk members.
The ISL Connection between masters will have its
own ID in this column.
Non trunk ISLs will have the default value of -1.
int
SOURCE_MASTER_PORT This column will hold the trunk master port for the
source port, if the connection is trunked.
For the master connection it will have its source
por''s port number.
For non-trunk connections it will have the default
value -1.
int
TARGET_MASTER_PORT This column will hold the trunk master port for the
target port, if the connection is trunked.
For the master connection it will have its target
port''s port number.
For non-trunk connections it will have the default
value -1.
int
TABLE 235 ISL_TRUNK_GROUP
Field Definition Format Size
ID* Primary key for the table. int
VIRTUAL_SWITCH_ID Foreign key reference to Virtual Switch record
associated with the trunk group.
int
MASTER_USER_PORT Stores the master user port for the ISL trunk.. smallint
TRUSTED Denotes whether ISL trunk group is trusted or not. 0
denotes untrusted and 1 is for trusted.
smallint
TABLE 234 ISL_CONNECTION
Field Definition Format Size