Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1615

Advertising
background image

Brocade Network Advisor SAN User Manual

1563

53-1003154-01

Database tables and fields

H

TYPE

Initiator or target or both or unknown. The possible
values are Initiator, Target, Initiator+Target,
Unknown(Initiator or Target)

varchar

32

DEVICE_TYPE

0 = physical
1 = virtual
2 = NPV
3 = iSCSI
4 = both physical & virtual

smallint

SYMBOLIC_NAME

Device node symbolic name.

varchar

256

FDMI_HOST_NAME

Device node FDMI host name.

varchar

128

VENDOR

Device node vendor.

varchar

64

CAPABILITY_

varchar

16

TRUSTED

1 = the node is trusted for "fabric tracking.
Default value is 0.

smallint

CREATION_TIME

Timestamp when the record is created by the
Management application server.

timestamp

MISSING

1 = the device node is missing from the fabric.
Default value is 0.

smallint

MISSING_TIME

Time when the device node missed.

timestamp

PROXY_DEVICE

One of the device ports of this device node has
translated domain. That device port is set as the Proxy
Device and this Device Node is treated as virtual by
assigning a value of 1 to this field.
Default value is 0.

smallint

AG

1 = the device node is actually an AG connected to a
switch in the fabric.
Default value is 0.

smallint

PREVIOUS_MISSING_STAT
E

Default value is 0.

smallint

TABLE 104

DEVICE_PORT

Field

Definition

Format

Size

NODE_ID

Reference to the ID of the Device Node of which this
device port is a part of.

int

DOMAIN_ID

Stores the Domain ID of the switch to which this
device port is connected to.

int

WWN

Stores the Device Port WWN

char

23

SWITCH_PORT_WWN

Stores the switch port wwn to which this device port
is physically connected to. However If the device is
connected to an AG, this will contain the switch port
WWN till the AG impact is applied by the application.
If AG impact fails to be applied this will continue to
have the switch port wwn instead of the AG port
wwn.

char

23

NUMBER

Stores the port number of this device port.

smallint

TABLE 103

DEVICE_NODE (Continued)

Field

Definition

Format

Size

Advertising