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

1004 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TABLE 106 FICON_DEVICE_PORT
Field Definition Format Size
DEVICE_PORT_ID* Value for the device port to which these FICON
properties are applied.
int
TYPE_NUMBER varchar 16
MODEL_NUMBER Ficon device model number, such as S18. varchar 64
MANUFACTURER Manufacturer of the device, typically IBM. varchar 64
MANUFACTURER_PLANT Plant number where the device is manufactured. varchar 64
SEQUENCE_NUMBER Device sequence number. varchar 32
TAG FICON device property, e.g., 809a or 809b. varchar 16
FLAG FICON device property, e.g., 0x10 (hex). varchar 8
PARAMS FICON device property string, e.g., Valid channel port. varchar 16
TABLE 107 DEVICE_NODE
Field Definition Format Size
ID* int
FABRIC_ID Fabric DB ID to which this device node belongs. int
WWN Device node WWN. char 23
TYPE Initiator or target or both or unknown. 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.
Default is ’now()’.
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