Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1003
53-1002167-01
Database tables and fields
E
Device
TABLE 105 DEVICE_PORT
Field Definition Format Size
ID* int
NODE_ID DB ID of the device node to which this port belongs. int
DOMAIN_ID Domain ID of the switch to which this device port is
attached.
int
WWN Device port WWN. char 23
SWITCH_PORT_WWN WWN of the switch port to which this device port is
attached.
char 23
NUMBER Switch port number to which this device is attached. smallint
PORT_ID Device port ID. varchar 6
TYPE Device port type, such as N or NL. varchar 32
SYMBOLIC_NAME Device port symbolic name. varchar 256
FC4_TYPE FC payload protocol. varchar 64
COS FC class of service. varchar 16
IP_PORT varchar 63
HARDWARE_ADDRESS varchar 32
TRUSTED 1 if found at discovery time or user has entrusted this
device port explicitly.
Default value is 0.
smallint
CREATION_TIME When the device port was discovered, i.e., created in
the DB.
default is ’now()’.
timestamp
MISSING 1 if that device port is missing from the fabric.
Default value is 0.
smallint
MISSING_TIME Time when it misses. timestamp
NPV_PHYSICAL Update NPV device type on this given device port. The
value "npvPhysical" on the device port will be 1 when
the device port has reference to a device node of
DEVICE_TYPE value 0 i.e. physical. It points to a switch
port to which at least one other device port points; and
that other pointing device port has reference to a
device node of DEVICE_TYPE value 2 (NPV).
smallint
EDGE_SWITCH_PORT_WW
N
Edge switch port WWN will be the same as the
Switch_Port_WWN except in the case of devices
behind the AG. This field will be updated by the name
server info collector, added for the feature support of
AG WWN N port mapping. This is a null able field. It is
used to determine which mapping is used by the AG.
char 23