Views I

FCIP_TUNNEL.MISMATCHED_CONFIG_DETAILS, FCIP_TUNNEL.SLOT_NUMBER, FCIP_TUNNEL.FICON_ENABLED, FCIP_TUNNEL.TPERF_ENABLED, FCIP_TUNNEL.AUTH_KEY,

FCIP_TUNNEL.CONNECTED_COUNT,

FCIP_TUNNEL.TUNNEL_STATUS_STRING, FCIP_TUNNEL.COMPRESSION_MODE, FCIP_TUNNEL.TURBO_WRITE_ENABLED, FCIP_TUNNEL.TAPE_ACCELERATION_ENABLED, FCIP_TUNNEL.IPSEC_ENABLED, FCIP_TUNNEL.PRESHARED_KEY, FCIP_TUNNEL.QOS_HIGH,

FCIP_TUNNEL.QOS_MEDIUM, FCIP_TUNNEL.QOS_LOW,

FCIP_TUNNEL.BACKWARD_COMPATIBLE,

FCIP_TUNNEL.FICON_TERADATA_READ_ENABLED,

FCIP_TUNNEL.FICON_TERADATA_WRITE_ENABLED, PORT.WWN as VIRTUAL_PORT_WWN, PORT.REMOTE_PORT_WWN as REMOTE_PORT_WWN, PORT.REMOTE_NODE_WWN as REMOTE_NODE_WWN, PORT.ID as SWITCH_PORT_ID, PORT.PORT_NUMBER as SWITCH_PORT_NUMBER, PORT.USER_PORT_NUMBER as USER_PORT_NUMBER, PORT.PORT_INDEX,

PORT.STATUS_MESSAGE from

FCIP_TUNNEL left outer join

FCIP_PORT_TUNNEL_MAP on

FCIP_PORT_TUNNEL_MAP.TUNNEL_ID = FCIP_TUNNEL.ID left outer join SWITCH_PORT PORT

on FCIP_PORT_TUNNEL_MAP.SWITCHPORT_ID = PORT.ID;

FCOE_DEVICE_INFO

create or replace view FCOE_DEVICE_INFO as select

FCOE_DEVICE.DEVICE_NODE_ID,

FCOE_DEVICE.DIRECT_ATTACH, FCOE_DEVICE.ATTACH_ID, FCOE_DEVICE.MAC_ADDRESS, DEVICE_NODE.TRUSTED, DEVICE_NODE.CREATION_TIME, DEVICE_NODE.MISSING, DEVICE_NODE.MISSING_TIME

from

FCOE_DEVICE,

DEVICE_NODE where

FCOE_DEVICE.DEVICE_NODE_ID = DEVICE_NODE.ID;

FRU_INFO

create or replace view FRU_INFO as select

FRU.ID,

FRU.CORE_SWITCH_ID,

Brocade Network Advisor IP User Manual

1625

53-1003056-01

 

Page 1677
Image 1677
Brocade Communications Systems IP250 user manual Fcoedeviceinfo, Fruinfo