Database tables and fields

I

TABLE 101 DEVICE_PORT

 

 

 

 

 

 

 

Field

Definition

Format

Size

 

 

 

 

MISSING

Denotes if this device port is missing or not.

smallint

 

 

 

 

 

MISSING_TIME

Denotes the time from which the device port is

timestamp

 

 

missing. Applicable only if the device is missing.

 

 

 

 

 

 

NPV_PHYSICAL

Denotes if this is physical device port or a logical

smallint

 

 

NPIV port.

 

 

 

 

 

 

EDGE_SWITCH_PORT_WWN

EDGE_SWITCH_PORT_WWN will be the same as the

char

23

 

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.

 

 

 

 

 

 

LOGGED_TO_AG

Indicates if the device is connected with an AG. Not

smallint

 

 

null field and default value is 0, device not

 

 

 

connected to AG

 

 

 

 

 

 

AG_NODE_WWN

If the device is connected with an AG, the AG switch

char

23

 

WWN will be populated. Not null field and default

 

 

 

value is empty

 

 

 

 

 

 

AG_N_PORT_WWN

If the device is connected with an AG, N-Port WWN

char

23

 

of AG which is connected to switch will be populated

 

 

 

from the N2F and N2WWN map

 

 

 

 

 

 

MISSING_REASON

The device missing reason.

varchar

1024

 

 

 

TABLE 102 DEVICE_PORT_GIGE_PORT_LINK

 

 

 

 

 

 

Field

Definition

Format

Size

 

 

 

 

DEVICE_PORT_ID

The primary key of the DevicePort

int

 

 

 

 

 

GIGE_PORT_ID

The primary key of the GigEPort.

int

 

 

 

 

 

DIRECT_ATTACH

Indicates whether the device port is directly attached

smallint

 

 

to the CEE 10G TE port.

 

 

 

 

 

 

VIRTUAL_FCOE_PORT_ID

The value of virtual_fcoe_port_id in the

int

 

 

Device_Port_Gige_Port_Link table is applicable only

 

 

 

for NOS devices. For FOS devices, the

 

 

 

virtual_fcoe_port_id value, will be null, as currently in

 

 

 

the Management application that mapping data is not

 

 

 

collected. Hence the default value is null.

 

 

 

 

 

 

LAG_ID

LAG interface ID which associates port channel with

int

 

 

end device. This will be null if device port is associated

 

 

 

with physical gige port.

 

 

 

 

 

TABLE 103 DEVICE_PORT_MAC_ADDRESS_MAP

 

 

 

 

 

 

Field

Definition

Format

Size

 

 

 

 

DEVICE_PORT_ID

The primary key of the device port

int

 

 

 

 

 

MAC_ADDRESS

Mac address of the device

varchar

64

 

 

 

 

Brocade Network Advisor IP User Manual

1415

53-1003056-01

 

Page 1467
Image 1467
Brocade Communications Systems IP250 user manual Deviceportgigeportlink, Deviceportmacaddressmap