Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1669

Advertising
background image

Brocade Network Advisor SAN User Manual

1617

53-1003154-01

Database tables and fields

H

TRUSTED

Denotes whether ISL link is trusted or not.

0 denotes untrusted

1 denotes trusted.

smallint

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 197

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

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

CREATION_TIME

Creation timestamp.

timestamp

TABLE 196

ISL (Continued)

Field

Definition

Format

Size

Advertising