Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2157

Advertising
background image

2120

Brocade Network Advisor SAN + IP User Manual

53-1002949-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:
"<port_wwn>: <disabled_reason> ; <port_wwn>:
<disabled_reason>".

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

Advertising