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

Brocade Network Advisor SAN User Manual 1143
53-1002167-01
Database tables and fields
E
PATH_POLICY Determines how multiple paths to this LUN are used.
0 = fixed, 1 = Most Recently Used, 2 = Round Robin.
The default value is 0.
smallint
UUID Universal unique ID varchar 64
TABLE 393 VM_PATH
Field Definition Format Size
ID int
HOST_ID Identifies the host containing this path. This is a
foreign key reference to VM_HOST.ID
int
VM_ID
Identifies the VM using this path to a LUN. If the path
is used by the host hypervisor instead of a VM, VM_ID
is 0. When non-zero, this value matches
VIRTUAL_MACHINE.ID
int
LUN_ID Identifies the LUN that is assigned to the VM. Not a
foreign key, but the value matches VM_LUN.ID
int
NAME The VM-assigned name for this path. For VMware,
this is the device name, such as vmhba0:0:1.
varchar 128
FABRIC_ID
Identifies the fabric that contains this path. Not a for-
eign key reference. Copied here for convenience.
Determined by locating the HBA port WWN or target
port WWN in the DEVICE_PORT table. Zero if the fab-
ric is not managed. The default value is 0.
int
HBA_PORT_WWN The HBAs physical port WWN for this path char 23
VM_PORT_WWN
The initiator port WWN used by the VM. If NPIV is
used, this is a virtual port WWN assigned by the VM
to this HBA port. If NPIV is not used, this WWN is the
same as the HBA Port WWN
char 23
TARGET_PORT_WWN The port WWN of the destination target. char 23
ENABLED '0 = path disabled, 1 = path enabled.
The default value is 0.
smallint
ACTIVE 0 = path inactive, 1 = path active.
The default value is 0.
smallint
PREFERRED
0 = not preferred, 1 = preferred path. The preferred
path is used whenever available when the path pol-
icy is Fixed.The default value is 0.
smallint
USAGE
Identifies how a VMware VM uses this LUN. 0 = NA
(used for Hyper-V), 1 = VMFS (datastores), 2 = RDM
(Raw Device Mapping). The default value is 0.
smallint
HBA_NODE_WWN The HBA physical node WWN for this path char 23
TABLE 392 VM_LUN (Continued)
Field Definition Format Size