Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1546)

1492 Brocade Network Advisor IP User Manual
53-1002947-01
Database tables and fields
I
CREATION_TIME Creation time of the ISL record in the Management
application database. timestamp
MISSING Denotes whether ISL link is missing or not.
•
0 denotes present
•
1 states that ISL is missing
smallint
MISSING_TIME States the missing time of the this ISL. timestamp
missing_reason The ISL disabled reason. For an ISL either one or
both ends might have been disabled. This field will
capture the port disable message from both side of
ISL. The data is formatted as follows:
": ; :
". varchar 1024
TRUNKED Determines 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. smallint
TABLE 249 ISL_CONNECTION
Field Definition Format Size
ID The primary key of the table. int
FABRIC_ID This is the fabric ID int
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
TABLE 248 ISL (Continued)
Field Definition Format Size