Views

I

TABLE 515

ZONE_SET

 

 

 

 

 

 

 

Field

Definition

Format

Size

 

 

 

 

ID*

Unique generated database identifier.

int

 

 

 

 

 

ZONE_DB_ID

PK of owning zone DB.

int

 

 

 

 

 

NAME

Zone set name.

varchar

64

 

 

 

 

 

ACTIVE

1

= active zone set

smallint

 

 

0

= otherwise.

 

 

 

 

 

 

 

Views

ADAPTER_PORT_CONFIG_INFO

create or replace view ADAPTER_PORT_CONFIG_INFO as select

ADAPTER_PORT_CONFIG.ID,

ADAPTER_PORT_CONFIG.NAME as CONFIG_NAME, ADAPTER_PORT_CONFIG.TYPE as TYPE, ADAPTER_PORT_CONFIG_PROPERTY.NAME as PROPERTY_NAME, ADAPTER_PORT_CONFIG_DETAILS.VALUE as PROPERTY_VALUE

from

ADAPTER_PORT_CONFIG,

ADAPTER_PORT_CONFIG_DETAILS,

ADAPTER_PORT_CONFIG_PROPERTY where

ADAPTER_PORT_CONFIG.ID = ADAPTER_PORT_CONFIG_DETAILS.CONFIG_ID

and ADAPTER_PORT_CONFIG_PROPERTY.ID= ADAPTER_PORT_CONFIG_DETAILS.PROPERTY_ID;

AG_CONNECTION_INFO

create or replace view AG_CONNECTION_INFO as select

AG_N_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID, AG_N_PORT.ID as SOURCE_PORT_ID, AG_N_PORT.WWN as SOURCE_PORT_WWN, AG_N_PORT.TYPE as SOURCE_PORT_TYPE,

AG_N_PORT.USER_PORT_NUMBER as SOURCE_USER_PORT_NUMBER, EDGE_F_PORT.VIRTUAL_SWITCH_ID as DESTINATION_SWITCH_ID, EDGE_F_PORT.ID as DESTINATION_PORT_ID, EDGE_F_PORT.WWN as DESTINATION_PORT_WWN, EDGE_F_PORT.TYPE as DESTINATION_PORT_TYPE,

EDGE_F_PORT.USER_PORT_NUMBER as DESTINATION_USER_PORT_NUMBER

from

SWITCH_PORT AG_N_PORT,

SWITCH_PORT EDGE_F_PORT where

((AG_N_PORT.REMOTE_PORT_WWN = EDGE_F_PORT.WWN)

or (AG_N_PORT.REMOTE_PORT_WWN = EDGE_F_PORT.LOGICAL_PORT_WWN and EDGE_F_PORT.TRUNK_MASTER = 1))

and AG_N_PORT.TYPE = 'N-Port';

Brocade Network Advisor IP User Manual

1601

53-1003056-01

 

Page 1653
Image 1653
Brocade Communications Systems IP250 user manual Views, Adapterportconfiginfo, Agconnectioninfo, Zoneset