Individual Cisco DCNM for SAN Database Schema Tables
The individual schema tables contain the column name, the JDBC SQL data type, and a description. Footnoted after each table are the indexes defined against columns in that table. The following tables are described in this section:
BASE_SVC_CLUSTER
Table 1-11 describes the cluster configurations in the CLUSTER database schema table.
Table 1-11 BASE_SVC_CLUSTER
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry in the table. |
FABRIC_ID |
INTEGER |
— |
Describes the ID of the parent fabric. |
CLUSTER_ID |
VARCHAR2(255) |
— |
Describes the ID of the cluster. |
NAME |
VARCHAR2(255) |
— |
Describes the name of the cluster. |
CLUSTER_TYPE |
INTEGER |
— |
Describes the cluster type. |
STATE |
INTEGER |
— |
Describes the cluster state. |
IS_MASTER |
NUMBER(1) |
— |
Describes whether this is the master IP. |
MASTER_ADDR_TYPE |
INTEGER |
— |
Describes the master switch address type. |
MASTER_ADDR |
VARCHAR2(255) |
— |
Describes the master switch address. |
MASTER_IP |
VARCHAR2(255) |
— |
Describes the IP address of the master switch. |
SWITCH_ID |
INTEGER |
— |
Describes the ID of the switch. |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the end port exists in any of the VSANs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
CARD (Deprecated)
Note The CARD Cisco DCNM for SAN database schema table is no longer in use.
CARD
Table 1-12 describes the card configurations in the CARD database schema table.
Table 1-12 CARD
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry in the table. |
CARD_SLOT |
INTEGER |
— |
Describes the card slot number. |
SWITCH_ID |
INTEGER |
— |
Provides the ID of the switch that generated the event. |
NAME |
VARCHAR2(256) |
— |
Describes the name of the enclosure. |
TYPE |
INTEGER |
— |
Describes the type of the event. |
HW_VERSION |
VARCHAR2(256) |
— |
Provides the hardware version |
SW_VERSION |
VARCHAR2(256) |
— |
Provides the firmware version. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Provides the sequence number assigned to the peer node during manufacturing. |
ASSET_ID |
VARCHAR2(256) |
— |
Provides the asset ID of the hardware component. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
STATUS |
INTEGER |
— |
Describes the status of the card. |
MODEL_NAME |
VARCHAR2(256) |
— |
Describes the model name of the hardware component. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
CONFIG_FILE
Table 1-13 describes the configuration file information in the CONFIG_FILE database schema table.
Table 1-13 CONFIG_FILE
|
|
|
|
DOCUMENT_NAME |
VARCHAR2(256) |
UNIQUE |
Describes the name of the configuration file document. |
USER_NAME |
VARCHAR2(256) |
UNIQUE |
Provides the username encrypted for security. |
CONTENT |
CLOB |
— |
Describes the configuration files content. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
DEVICE_ALIAS
Table 1-14 describes the device alias information in the DEVICE_ALIAS database schema table.
Table 1-14 DEVICE_ALIAS
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry in the table. |
FABRIC_ID |
INTEGER |
— |
Describes the ID of the parent fabric. |
CFS_REGION_ID |
INTEGER |
— |
Describes the ID of the CFS region. |
WWN |
RAW(8) |
— |
Describes the WWN of the end port. |
ALIAS |
VARCHAR2(256) |
— |
Describes the device alias. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
ENCLOSURE
Table 1-15 describes an enclosure, which can be a physical or virtual entity in the ENCLOSURE database schema table.
Table 1-15 ENCLOSURE
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
NAME |
VARCHAR2 (256) |
— |
Describes the name of the enclosure. |
IS_VIRTUAL |
NUMBER1 |
— |
Describes whether the enclosure is virtual. |
ENC_TYPE |
INTEGER |
— |
Describes the type of the enclosure. |
OS_INFO |
VARCHAR2 (256) |
— |
Provides the operating system of the enclosure. |
IP_ADDRESS |
VARCHAR2 (256) |
— |
Provides the IP address of the enclosure. |
DM_PATH |
VARCHAR2 (256) |
— |
Describes the device manager path of the enclosure. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
SAN_ID |
INTEGER |
— |
Deprecated. |
VENDOR |
VARCHAR2 (256) |
— |
Deprecated. |
MODEL |
VARCHAR2 (256) |
— |
Deprecated. |
VERSION |
VARCHAR2 (256) |
— |
Provides the version of the enclosure. |
VHOST_ID |
INTEGER |
— |
Describes the VHost ID for an ESX host enclosure. |
IS_VM_HOST |
NUMBER(1) |
— |
Indicates if it is a virtual host through the boolean value. |
SERVICE_PROFILE |
VARCHAR2 (256) |
— |
Indicates if it is a UCS server blade enclosure through the Service profile name. |
SERVER_BLADE |
VARCHAR2 (256) |
— |
Indicates if this is a UCS server blade enclosure through the Server blade name. |
RESERVE_COL1 |
VARCHAR2 (256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2 (256) |
— |
Deprecated. |
END_PORT
This table describes an end port within a fabric. Use the FABRIC_ID to associate this end port with a fabric in the FABRIC table. Use the ENCLOSURE_ID to associate this end port with an enclosure in the ENCLOSURE table. Use the HBA_ID to associate this end port with an HBA in the HBA table. Use the PORT_ID to associate this end port with a port in the SWITCH_PORT table. Table 1-16 describes the END_PORT database schema table.
Table 1-16 END_PORT
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the primary key of the entity. |
FABRIC_ID |
INTEGER |
— |
Describes the ID of the parent fabric. |
ENCLOSURE_ID |
INTEGER |
— |
Describes the ID of the enclosure to which the end port belongs. |
HBA_ID |
INTEGER |
— |
Describes the ID of the HBA to which the end port belongs. |
SWITCH_PORT_ID |
INTEGER |
— |
Describes the ID of the switch port that linked to the end port. |
WWN |
RAW(8) |
— |
Provides the WWN of the end port. |
NODE_WWN |
RAW(100) |
— |
Provides the WWN of the node. |
FICON_PORT_ADDRESS |
RAW(100) |
— |
Describes the FICON address of the end port. |
FLAGS |
INTEGER |
— |
Deprecated. |
SYM_PORT_NAME |
VARCHAR2(256) |
— |
Describes the symbolic name of the end port. |
SYM_NODE_NAME |
VARCHAR2(256) |
— |
Describes the symbolic name of the parent node. |
PORT_IP_ADDR |
VARCHAR2(256) |
— |
Provides the IP address of the parent node. |
ALIAS |
VARCHAR2(256) |
— |
Describes the port alias. |
IS_PRESENT |
NUMBER(1) |
— |
Describes whether the end port exists in any of the VSANs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds, since 1/1/1970. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes if the link is down, the value represents the status. Refer to values for FcIfOperStatusReason in CISCO-FC-FE-MIB. |
IF_NAME |
VARCHAR2(256) |
— |
Describes the interface name of the attached switch port. |
IS_LOOP |
NUMBER(1) |
— |
Describes whether the link is an arbitrated loop. |
FC4_TYPES |
RAW(100) |
— |
Describes the FC4 types of the end port. Refer to values for fcNameServerFC4Type in CISCO-NS-MIB. |
FC4_FEATURES |
INTEGER |
— |
Describes the FC4 features of the end port. Refer to values for fcNameServerFC4Features in CISCO-NS-MIB. |
NAME |
VARCHAR2(256) |
— |
Describes the logical name of the end port. |
VFC_BINDTO |
VARCHAR2(256) |
— |
Describes the VFC (virtual FC) bind information for end port. |
SERVICE_PROFILE |
VARCHAR2(256) |
— |
Indicates if this is a UCS server end point through the Service profile name. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VHOST
This table describes the virtual host. Table 1-17 describes the VHOST database schema table.
Table 1-17 VHOST Enclosure Table
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the host. |
VCENTER_ID |
INTEGER |
— |
Provides the ID of vCenter from where the vhost is discovered. |
CLUSTER_ID |
INTEGER |
— |
Provides the ID of the cluster. |
NAME |
VARCHAR2(256) |
— |
Provides the name of the host. |
FULL_NAME |
VARCHAR2(256) |
— |
Provides the full qualified name including the domain name. |
MOREF |
VARCHAR2(256) |
— |
Provides the MOF reference. |
MAC_ADDRESS |
VARCHAR2(256) |
— |
Provides the MAC address for the vHost ( ESX server). |
IP_ADDRESS |
VARCHAR2(256) |
— |
Describes the IP address of the host. |
OS_INFO |
VARCHAR2(256) |
— |
Provides the operating system of the host. |
VENDOR |
VARCHAR2(256) |
— |
Provides the vendor name. |
MODEL |
VARCHAR2(256) |
— |
Describes the model of the hardware component. |
VERSION |
VARCHAR2(256) |
— |
Provides the version of the switch. |
MEMORY_SIZE |
NUMBER(20) |
— |
Provides the memory size. |
CPUCOUNT |
INTEGER |
— |
Provides the number of CPUs. |
CPU_SPEED_AVG |
NUMBER(20) |
— |
Provides the average CPU speed. |
HBAS |
VARCHAR2(256) |
— |
Provides the HBA information. |
MULTIPATH |
VARCHAR2(256) |
— |
Provides the multipath information. |
ALIASES |
VARCHAR2(256) |
— |
Provides the alias associated with the device. |
CONN_STATE |
INTEGER |
— |
Provides the connection state. |
POWER_STATE |
INTEGER |
— |
Provides the power state. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN-TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VM
This table describes the virtual machine. Table 1-18 describes the VM database schema table.
Table 1-18 VM Enclosure Tables
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the host. |
VCENTER_ID |
INTEGER |
— |
Provides the ID of vCenter from where the VM is discovered. |
CLUSTER_ID |
INTEGER |
— |
Provides the ID of the cluster. |
NAME |
VARCHAR2(256) |
— |
Provides the virtual machine name. |
MOREF |
VARCHAR2(256) |
— |
Provides the MO reference string. |
MEMORY_SIZE |
NUMBER(20) |
— |
Provides the memory allocation for the VM. |
CPUCOUNT |
INTEGER |
— |
Provides the CPU allocated for the VM. |
OS_TYPE |
VARCHAR2(256) |
— |
Provides the type of the operating system of the host. |
DNS_NAME |
VARCHAR2(256) |
— |
Provides the VM DNS name. |
IP_ADDRESS |
RAW(100) |
— |
Describes the IP address of the host. |
POWER_STATE |
INTEGER |
— |
Describes the power state. |
DISK_READ_AVG |
NUMBER |
— |
Provides the Average disk read (Bytes per Second). |
DISK_WRITE_AVG |
NUMBER |
— |
Provides the Average disk read (Bytes per Second). |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN-TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
DATA_STORE
This table describes the data store defined in vCenter. Table 1-19 describes the DATA_STORE database schema table.
Table 1-19 DATA STORE Enclosure Table
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the host. |
VCENTER_ID |
INTEGER |
— |
Provides the ID of the vCenter from where the data store is discovered. |
FABRIC_ID |
INTEGER |
— |
Provides the ID of the fabric. |
NODE_WWN |
RAW(100) |
— |
Provides the storage node world wide name. |
PORT_WWN |
RAW(100) |
— |
Provides the storage port world wide name. |
LUN-UUID |
VARCHAR2(256) |
— |
Provides the LUN UUID for the data store. |
LUN |
INTEGER |
— |
Provides the LUN for the data store. |
SCSI_LUN |
VARCHAR2(256) |
— |
Provides the SCSI LUN for the data store. |
UUID |
VARCHAR2(256) |
— |
Provides the UUID for the data store. |
CANONICAL_NAME |
VARCHAR2(256) |
— |
Provides a canonical nam e for the data store. |
URL |
VARCHAR2(256) |
— |
Provides the URL. |
NAME |
VARCHAR2(256) |
— |
Provides the name. |
FREE_SPACE |
NUMBER(20) |
— |
Provides the free storage space. |
MAX_FILESIZE |
NUMBER(20) |
— |
Provides the maximum file size. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN-TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
ENC_DATASTORE_INFO
This table provides the relationship table between enclosure and data store. Table 1-20 describes the ENC_DATASTORE_INFO database schema table.
Table 1-20 ENC_DATASTORE_INFO Enclosure Table
|
|
|
|
ENCLOSURE_ID |
INTEGER |
NOT NULL |
Provides the ID of the enclosure containing the target. |
DATASTORE_ID |
INTEGER |
NOT NULL |
Provides the ID for the data store. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VM_DATASTORE_INFO
This table provides the relationship table between the virtual machine and data store. Table 1-21 describes the VM_DATASTORE_INFO database schema table.
Table 1-21 VM_DATASTORE_INFO Enclosure Table
|
|
|
|
VM_ID |
INTEGER |
NOT NULL |
Provides the ID of the virtual machine. |
DATASTORE_ID |
INTEGER |
NOT NULL |
Provides the ID for the data store. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
EVENTS
This table describes Performance Manager events. Use the FABRICID to associate this event with a fabric in the FABRIC table. Use the SWITCHID to associate this event with a switch in the SWITCH table. Table 1-22 describes the EVENTS database schema table.
Table 1-22 EVENTS
|
|
|
|
EVENTID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the event. |
FIRST_SEEN |
TIMESTAMP |
— |
Describes the host time of the event. |
SWITCH_TIME |
TIMESTAMP |
— |
Describes the switch time of the event. |
TYPE |
INTEGER |
— |
Type of the event. See Table 1-23 . |
FACILITY |
VARCHAR2(20) |
— |
Describes the facility for syslog. |
SEVERITY |
INTEGER |
— |
Describes the severity of the event: 0 = emergency 1 = alert 2 = critical 3 = error 4 = warning 5 = notice 6 = info 7 = debug |
SOURCE |
VARCHAR2(256) |
DEFAULT |
Describes the source fabric that generated the event. |
DESCR |
VARCHAR2(4000) |
DEFAULT |
Describes the description of the event. |
SYSLOGEVENT |
VARCHAR2(80) |
— |
Describes the system log events. |
VSANID |
INTEGER |
DEFAULT |
Describes the ID of the VSAN that generated the event. |
DCID |
INTEGER |
— |
Describes the ID of the fabric that generated the event. |
SWITCHID |
INTEGER |
— |
Describes the ID of the switch that generated the event. |
SRCID |
INTEGER |
— |
Describes the ID of the source port; applies to Performance Manager events only. |
DESTID |
INTEGER |
— |
Describes the ID of the destination port; applies to Performance Manager events only. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
ENCLOSURE_ID |
INTEGER |
DEFAULT -1 |
Decribes the ID of the event enclosure. |
GROUP_ID |
INTEGER |
DEFAULT- 1 |
Describes the ID of the group the generated the event. |
ACK |
NUMBER(1) |
DEFAULT 0 |
|
DCTYPE |
NUMBER(1) |
DEFAULT 0 |
|
LAST_SEEN |
TIMESTAMP |
— |
Provides the time when the event was last seen. |
COUNT |
NUMBER(22) |
DEFAULT 0 |
Provides the number of times the event has occurred. |
Table 1-23 TYPE Field Description in EVENTS Table
|
|
0 |
other |
1 |
switch discovered |
2 |
switch rebooted |
3 |
switch unreachable |
4 |
switch manageable |
5 |
switch unmanageable |
6 |
switch IP changed |
7 |
VSAN added |
8 |
VSAN unreachable |
9 |
VSAN up |
10 |
VSAN down |
11 |
VSAN merged |
12 |
VSAN segmented |
13 |
zone set changed |
14 |
principal switch changed |
15 |
ISL up |
16 |
ISL unreachable |
17 |
N_Port up |
18 |
N_Port unreachable |
19 |
N_Port moved |
20 |
enclosure added |
21 |
enclosure removed |
22 |
binding denied |
23 |
switch of activity |
24 |
service or process restarted |
25 |
fan tray changed |
26 |
power changed |
27 |
module changed |
28 |
FRU inserted |
29 |
FRU removed |
30 |
zone merged |
31 |
fabric changed |
32 |
fabric opened |
33 |
fabric closed |
34 |
license manager |
35 |
image upgraded |
36 |
VRRP |
37 |
IVR |
38 |
FICON |
39 |
server down |
40 |
threshold exceeded |
41 |
CFS |
42 |
SAN removed |
43 |
fabrics merged |
44 |
fabric split |
45 |
feature |
46 |
FM license violation |
47 |
fabric purged |
48 |
RMON events |
49 |
sensor events |
EVENT_FORWARD
Table 1-24 describes the event-forward configurations in the EVENT_FORWARD database schema table.
Table 1-24 EVENT_FORWARD
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
TYPE |
INTEGER |
— |
Describes the type of the event forward entry: trap = 1 email = 2 |
FID |
INTEGER |
— |
Describes the ID of the fabric; 0 indicates all fabrics. |
VSAN_SCOPE |
VARCHAR2(256) |
— |
Describes the VSAN scope; for example, “1, 2, 10-14”, or “ALL”. |
SEVERITY |
INTEGER |
— |
Describes the severity to trigger the forward action: 0 = emergency 1 = alert 2 = critical 3 = error 4 = warning 5 = notice 6 = info 7 = debug |
ADDRESS |
VARCHAR2(256) |
— |
Describes the address of the event forward. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
ETHSWITCH
Table 1-25 describes the Ethernet switch configurations in the ETHSWITCH database schema table.
Table 1-25 Ethernet Switch
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry in the table. |
LICENSE_ID |
INTEGER |
— |
Describes the ID of the license. |
IP_ADDRESS |
RAW(100) |
— |
Describes the IP address of the switch. |
TYPE |
INTEGER |
— |
Describes the type of the switch. |
MODEL_NAME |
VARCHAR2(255) |
— |
Describes the model name of the hardware component. |
IS_MANAGEABLE |
NUMBER(1) |
— |
Describes the manageable switch. |
UNMANAGEABLE_CAUSE |
VARCHAR2(256) |
— |
Describes the unmanageable switch and its case. |
NUM_PORTS |
INTEGER |
— |
Describes the number port of the switch. |
GLOBAL_DEVICE_ID |
VARCHAR2(256) |
— |
Describes the global switch ID. |
DEVICE_ID |
VARCHAR2(256) |
— |
Describes the switch ID. |
CAPABILITY |
RAW(100) |
— |
Describes the switch capability. |
VTP_MGMT_DOMAIN |
RAW(1000) |
— |
Describes the VTV management domain. |
VLAN_LIST |
VARCHAR2(256) |
— |
Provides the list of VLANs. |
SYS_NAME |
VARCHAR2(256) |
— |
Describes the system name. |
SYS_CONTACT |
VARCHAR2(256) |
— |
Describes the system contact. |
SYS_LOCATION |
VARCHAR2(256) |
— |
Describes the system location. |
SYS_UPTIME |
INTEGER, |
— |
Describes the system uptime. |
VERSION |
VARCHAR2(256) |
— |
Provides the version of the switch. |
IS_PRESENT |
NUMBER(1) |
— |
Provides an indication of whether the switch exists currently. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Sequence number assigned to the peer node during manufacturing. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
SYS_DESCRIPTION |
VARCHAR2(256) |
— |
Describes the system description. |
VENDOR |
VARCHAR2(256) |
— |
Provides the name of the company that manufactured the peer node. |
OPER_MODE |
INTEGER |
— |
Operational mode of the link by port type: 1 = auto 2 = F 3 = FL 4 = E 5 = B 6 = FX 7 = SD 8 = TL 9 = N 10 = NL 11 = NX 12 = TE 13 = FV 14 = down 15 = ST |
IS_VDC |
NUMBER 1 |
— |
.Provides information if this is a VDC |
VDC_ID |
INTEGER |
— |
Provides the VDC ID. |
VDC_MAC |
RAW(6) |
— |
Provides the MAC address of the VDC. |
VDC_NAME |
VARCHAR2(256) |
— |
Provides name of the VDC. |
DEFAULT_VDC_MAC |
RAW(6) |
— |
Provides the defualt MAC address of the VDC |
VDC_STATE |
SMALLINT |
— |
Provides the current state of the VDC. |
FCOE_CAPABLE |
SMALLINT |
— |
Provides if the ethernet switch is capable of FCoE. |
FCOE_ENABLED |
NUMBER (1) |
— |
Provides if the ethernet switch is FCoE enabled. |
CPU_USAGE |
INTEGER |
— |
Provides information about the CPU usage of the ethernet switch. |
MEM_USAGE |
INTEGER |
— |
Provides information about the memory usage of the ethernet switch. |
IS_FEX |
NUMBER (1) |
— |
Provides information if the ethernet switch has fabric extender. |
FEX_ID |
INTEGER |
— |
Provides the fabric extender ID of the ethernet switch. |
FEX_ENABLED |
NUMBER (1) |
— |
Provides information if the fabic extender is enabled. |
DISC_STATUS |
INTEGER |
— |
|
DISC_DESCR |
VARCHAR2(256) |
— |
|
DEEP_DESC |
VARCHAR2(256) |
— |
|
LANSWITCH_CLASSID |
INTEGER |
— |
Describeses the LAN switch class ID. |
ETHSWITCH_PORT
Table 1-26 describes the Ethernet switch port configurations in the ETHSWITCH_PORT database schema table.
Table 1-26 Ethernet Switch Port
|
|
|
|
ID |
ID |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
IF_INDEX |
INTEGER |
— |
Describes the index of the Ethernet switch port. |
SWITCH_ID |
INTEGER |
— |
Describes the switch ID for each switch port. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
STATUS |
SMALLINT |
— |
Describes the status of the switch. |
IF_SPEED |
INTEGER |
— |
Describes the speed. |
IF_NAME |
VARCHAR2(256) |
— |
Describes the name. |
IF_TYPE |
INTEGER |
— |
Describes the type. |
IF_DESCR |
VARCHAR2(256) |
— |
Provides the description |
IP_ADDR |
VARCHAR2(256) |
— |
Provides the IP address. |
MTU |
INTEGER |
— |
Describes the MTU for the Ethernet switch. |
IS_CHANNEL |
NUMBER 1 |
— |
|
CHANNEL_ID |
INTEGER |
— |
Provides the channel ID. |
IS_TRUNK |
NUMBER (1) |
— |
|
NATIVE_VLANID |
INTEGER |
— |
Provides the native VLAN ID. |
SHARED_MODE |
INTEGER |
— |
Describes if the ethernet switchport is in shared mode. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the last scan time. |
IF_ALIAS |
VARCHAR2(255) |
— |
Describes the alias. |
IS_PHYSICAL |
NUMBER (1) |
— |
|
OPER_STATUS_CAUSE |
SMALLINT |
— |
|
IF_ADMINSTATUS |
SMALLINT |
— |
describes the administrator status. |
CDP_SEED
Table 1-27 describes the CDP_SEED configurations in the CDP_SEED database schema table.
Table 1-27 CDP SEED
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
LAN_ID |
INTEGER |
— |
Describes the LAN ID. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Sequence number assigned to the peer node during manufacturing. |
INET_ADDR |
RAW(100) |
— |
Describes the INET address. |
IP_RANGE |
VARCHAR2(256) |
— |
Describes the IP range. |
SUBNET |
VARCHAR2(256) |
— |
Describes the subnet. |
MASK |
VARCHAR2(256) |
— |
Describes the mask. |
CRED_ID |
INTEGER |
— |
Describes the credentation ID. |
MAX_HOPS |
INTEGER |
— |
Describes the maximum number of hops. |
PLATFORM |
VARCHAR2(256) |
— |
Describes the platform. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
SEED_TYPE |
INTEGER |
— |
Describes the seed type. |
DISC_STATE |
INTEGER |
— |
|
IP_LIST |
VARCHAR2(4000) |
— |
Provides the list of IP addresses. |
GROUP_ID |
INTEGER |
— |
Provides the group ID. |
CREATE_TIME |
INTEGER |
— |
Provides the creation times. |
ENABLE_PWD |
VARCHAR2(256) |
— |
Describes if password protectio n is enabled. |
DCNM_USER |
VARCHAR2(256) |
— |
Describes the DCNM user. |
DEEP_TASKID |
INTEGER |
— |
|
DEEP_DESC |
VARCHAR2(256) |
— |
|
DEEP_UPDATETIME |
INTEGER |
— |
|
MANAGEABLE |
NUMBER (1) |
— |
|
FWSM |
NUMBER (1) |
— |
|
LAN
Table 1-28 describes the LAN configurations in the LAN database schema table.
Table 1-28 LAN
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
LAN_ID |
INTEGER |
— |
Provides the ID of the LAN. |
LAN_NAME |
VARCHAR2(256) |
— |
Provides the name of the LAN. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
IS_PERSISTENT |
NUMBER(1) |
— |
Describes whether the LAN is persistent. |
IS_MANAGEABLE |
NUMBER(1) |
— |
Describes whether the LAN is manageable. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
ETHSWITCH_PORT_VLAN
Table 1-29 describes the Ethernet switch port VLAN configurations in the ETHSWITCH_PORT_VLAN database schema table.
Table 1-29 ETHSWITCH_PORT_VLAN
|
|
|
|
PORT_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Identifier of the port in the peer node connected to this port. If the peer node is a control unit, this value will be 0. If the peer node is a channel, this value will be the channel path identifier of the channel path that contains the port in the peer node. If the peer node is a fabric, this value will be the port address of the port in peer node. Refer to CISCO-FC-FE-MIB for more information. |
VLAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the VLAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
ETHISL_VLAN
Table 1-30 describes the ethernet isl VLAN configurations in the ETHISL_VLAN database schema table.
Table 1-30 ETHISL_VLAN
|
|
|
|
ISL_ID |
INTEGER |
NOT NULL PRIMARY KEY |
ID of the ISL |
VLAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the VLAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
IS_CHANNEL |
NUMBER (1) |
— |
|
CHANNEL_ID |
INTEGER |
— |
Provides the channel ID. |
IS_TRUNK |
NUMBER (1) |
— |
|
NATIVE_VLANID |
INTEGER |
— |
Prvides the native VLAN ID |
ACCESS_VLANID |
INTEGER |
— |
Provides the access VLAN ID |
IS_FEXISL |
NUMBER (1) |
— |
Describes if fabric extended ISL is supported. |
FABRIC
Table 1-31 describes a SAN fabric in the FABRIC database schema table.
Table 1-31 FABRIC
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the primary key of the database entry. |
SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the switch where the fabric discovery originated. |
IVR_SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the switch where the IVR data originated. |
ALIAS_SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the alias switch. |
LICENSE_ID |
INTEGER |
— |
Deprecated. |
IVR_ENF_ZONESET_NAME |
VARCHAR2(256) |
— |
Provides the active IVR zone set name. |
IVR_ENF_ZONESET_ACTIVATE_TIME |
INTEGER |
— |
Provides the time in milliseconds when the IVR zone set is activated. |
IVR_ACTIVE_ZONESET_CHECKSUM |
RAW(100) |
— |
IVR active zone set checksum. |
POLLING_ENABLED |
NUMBER(1) |
— |
Describes the indication of whether the fabric is polled regularly. |
POLLING_INTERVAL |
INTEGER |
— |
Provides the fabric polling interval, in seconds. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
SNMP_RETRIES |
INTEGER |
— |
Provides the number of SNMP retries. |
SNMP_TIMEOUT |
INTEGER |
— |
Provides the SNMP timeout in milliseconds. |
FMUSER_ID |
INTEGER |
— |
Deprecated. |
NAME |
VARCHAR2(256) |
— |
Describes name of the fabric. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
SAN_ID |
INTEGER |
— |
Provides the ID of the parent SAN. |
FID |
INTEGER |
— |
Provides the ID of the fabric. |
IS_PERSISTENT |
NUMBER(1) |
— |
Indicates whether continuous monitoring is enabled. |
ON_DEMAND_POLL_FREQ |
INTEGER |
— |
On-demand polling interval for fabric discovery, in seconds. |
IVR_TOPO_CFG_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_ACT_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_AFID_CFG_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_DEF_AFID_CHECKSUM |
RAW(100) |
— |
Deprecated. |
IVR_TOPO_VALIDATED |
NUMBER(1) |
— |
Deprecated. |
USE_GLOBAL_ALIAS |
NUMBER(1) |
— |
Indicates whether the fabric is set to use the global alias. |
IS_MANAGEABLE |
NUMBER(1) |
— |
Describes whether the fabric is manageable. |
DEVICE_ALIAS_SEED_ID |
INTEGER |
— |
Describes the ID of the device alias seed. |
DEVICE_ALIAS_CHECKSUM |
RAW(100) |
— |
Describes the checksum for device alias database in the fabric. |
VSANS_INCLUDED |
VARCHAR2(256) |
DEFAULT ‘-1’ NULL |
Describes the VSANs included from the fabric. |
VSANS_EXLUDED |
VARCHAR2(256) |
DEFAULT ‘-1’ NULL |
Describes the VSANs excluded from the fabric. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
FAILED ATTEMPTS
This table describes the number of failed attempts by users. Table 1-32 describes the FAILED_ATTEMPTS database schema table.
Table 1-32 FAILED ATTEMPTS
|
|
|
|
USER_NAME |
VARCHAR2(256) |
PRIMARY KEY |
Provides the username encrypted for security. |
FAILED_ATTEMPT_TIME |
INTEGER |
PRIMARY KEY |
Describes the failed attempt time of each user. |
FICON_INFO
This table describes a FICON connection to a switch. Use the PORT_ID to associate this FICON connection to a port in the SWITCH_PORT table. Table 1-33 describes the FICON_INFO database schema table.
Table 1-33 FICON_INFO
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the interface ID. |
VENDOR |
VARCHAR2(256) |
— |
Provides the name of the company that manufactured the peer node. |
TYPE_NUM |
VARCHAR2(256) |
— |
Provides the type number of the peer node. |
MODEL_NUM |
VARCHAR2(256) |
— |
Provides the model number of the peer node. |
SERIAL_NUM |
VARCHAR2(256) |
— |
Provides the sequence number assigned to the peer node during manufacturing. |
PORT_ID |
VARCHAR2(256) |
— |
Provides the identifier of the port in the peer node connected to this port. If the peer node is a control unit, this value will be 0. If the peer node is a channel, this value will be the channel path identifier of the channel path that contains the port in the peer node. If the peer node is a fabric, this value will be the port address of the port in peer node. Refer to CISCO-FC-FE-MIB for more information. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
FMUSER
This table describes a Fabric Manager user. Table 1-34 describes the FMUSER database schema table.
Table 1-34 FMUSER
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the Cisco DCNM for SAN user. |
USER_NAME |
VARCHAR2(256) |
— |
Provides the username encrypted for security. |
AUTH_PASSWORD |
VARCHAR2(256) |
— |
Provides the authentication password encrypted for security. |
ROLE_NAME |
VARCHAR2(256) |
— |
Describes the user role name; can be either network administrator or operator. |
IS_LOGGING_IN |
NUMBER(1) |
— |
Provides the login status of the user. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
FMSESSION
This table describes the Cisco DCNM for SAN user session. Table 1-35 describes the FMSESSION database schema table.
Table 1-35 FMSESSION
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Specifies the ID of the entry in the table. |
SERVER_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the server ID of the Cisco DCNM for SAN session. |
CLIENT |
VARCHAR2(80) |
NOT NULL |
Describes the client in the Cisco DCNM for SAN session. |
IS_LOCAL |
NUMBER(1) |
NOT NULL |
Describes whether the Cisco DCNM for SAN session is local. |
USER_NAME |
VARCHAR2(80) |
NOT NULL |
Describes the username. |
AUTH_PASSWORD |
VARCHAR2(80) |
NOT NULL |
Specifies the password of the Cisco DCNM for SAN session user. |
ROLE_NAME |
VARCHAR2(80) |
NOT NULL |
Specifies the user role name; can be either network administrator or operator. |
LOGIN_TIME |
TIMESTAMP |
NOT NULL |
Describes the last login by a user. |
LAST_ACCESS_TIME |
TIMESTAMP |
NOT NULL |
Describes the last access time of the user. |
GROUPS
This table describes a Fabric Manager group within a fabric. Use the FABRIC_ID to associate this group to a fabric in the FABRIC table. Table 1-36 describes the GROUPS database schema table.
Table 1-36 GROUPS
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the group. |
FABRIC_ID |
INTEGER |
— |
Provides the ID of the fabric to which the group belongs. |
NAME1 |
VARCHAR2(256) |
— |
Describes the name of the group. |
TYPE |
INTEGER |
— |
Type of the group: 1 = switch 2 = end port |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
GROUP_FABRIC_INFO
This table describes the mapping between the user-defined logical groups and fabrics. Table 1-37 describes the GROUP_FABRIC_INFO database schema table.
Table 1-37 GROUP_FABRIC_INFO
|
|
|
|
GROUP_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the group. |
FABRIC_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the fabric to which the group belongs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
GROUP_MEMBER_INFO
This table describes a member of a group. Use the GROUP_ID to associate this member to a group. Use the MEMBER_ID to reference an ID in a SWITCH or END_PORT table. Table 1-38 describes the GROUP_MEMBER_INFO database schema table.
Table 1-38 GROUP_MEMBER_INFO
|
|
|
|
GROUP_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the group. |
MEMBER_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the group member, which is a switch or an end port ID. |
TYPE |
INTEGER |
— |
Describes the type of the group member: 1 = switch 2 = end port |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
GROUP_USER_INFO
This table describes a user of a group. Table 1-39 describes the GROUP_MEMBER_INFO database schema table.
Table 1-39 GROUP_USER_INFO
|
|
|
|
GROUP_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the group. |
FMUSER_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the Cisco DCNM for SAN user ID for each user. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
DCNMUSER
This table describes the DCNM users. Table 1-40 describes the DCNMUSER database schema table.
Table 1-40 DCNMUSER User Access Control Table
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the user. |
VERSION |
INTEGER |
— |
Provides the DCNM version. |
USERID |
VARCHAR2(256) |
NOT NULL |
Provides the unique user ID of the DCNM user. |
PASSWORD |
VARCHAR2(256) |
— |
Provides the password encrypted for security. |
ROLE |
VARCHAR2(256) |
— |
Describes the DCNM user role. |
HBA
This table associates a WWN to a host bus adapter. Use the ENCLOSURE_ID to associate each HBA to an enclosure in the ENCLOSURE table. Table 1-41 describes the HBA database schema table.
Table 1-41 HBA
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the HBA. |
ENCLOSURE_ID |
INTEGER |
— |
Provides the ID of the parent enclosure. |
HWWN |
RAW(8) |
— |
Describes the HBA WWN, one of its port WWNs. |
NWWN |
RAW(8) |
— |
Describes the node WWN. |
TYPE |
SMALLINT |
— |
Deprecated. |
MANUFACTURER |
VARCHAR2(256) |
— |
Provides the manufacturer name. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Provides the serial number of the HBA. |
MODEL |
VARCHAR2(256) |
— |
Provides the model of the HBA. |
MODEL_DESCRIPTION |
VARCHAR2(256) |
— |
Provides the model description of the HBA. |
HW_VERSION |
VARCHAR2(256) |
— |
Provides the hardware version. |
SW_VERSION |
VARCHAR2(256) |
— |
Provides the firmware version. |
DRIVER_VERSION |
VARCHAR2(256) |
— |
Provides the driver version. |
OPT_ROM_VERSION |
VARCHAR2(256) |
— |
Optional ROM version. |
OS |
VARCHAR2(256) |
— |
Deprecated. |
IP_ADDRESS |
VARCHAR2(256) |
— |
Provides the IP address of the HBA. |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the HBA exists. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
STATUS |
INTEGER |
— |
Deprecated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
HW_CARD
This table provides the power and status indications for a hardware component. Use the HW_COMPONENT_ID to associate each row to a hardware component in the HW_COMPONENT table. Table 1-42 describes the HW_CARD database schema table.
Table 1-42 HW_CARD
|
|
|
|
HW_COMPONENT_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in HW_COMPONENT table. |
MODEL_TYPE |
INTEGER |
— |
Provides the model type of the card. See Table 1-43 . |
ADMIN_STATUS |
INTEGER |
— |
Describes the administrative status of the card: 1 = enabled 2 = disabled 3 = reset 4 = out of service |
OPER_STATUS |
INTEGER |
— |
Provides the operational status of the card. See Table 1-44 . |
RESET_REASON |
VARCHAR2(256) |
— |
Provides the reset reason for the card. |
STATUS_LAST_CHANGE_TIME |
INTEGERs |
— |
Provides the last status change time in hundredths of seconds. |
POWER_ADMIN_STATUS |
INTEGER |
— |
Describes the administrative status of the power for the card: 1 = on 2 = off 3 = inline automatic 4 = inline on |
POWER_OPER_STATUS |
INTEGER |
— |
Describes the operational status of the power for the card: 1 = off for environment or other reason 2 = on 3 = off for administration 4 = off denied 5 = off for environmental power 6 = off for environmental temperature 7 = off for environmental fan 8 = failed 9 = on but fan failed |
POWER_CURRENT |
INTEGER |
— |
Describes the current measurement on the system power supply primary output. The range is from -1.0 x 106 A to 1.0 x 106 A. A negative value expresses the current used by the FRU. A positive value expresses the current supplied by the FRU. |
DMM_STATE |
INTEGER |
— |
Describes whether the module is capable on DMM (data migration). |
IOA_STATE |
INTEGER |
— |
Describes the IOA state. |
SE_STATE |
INTEGER |
— |
Describes the SE state. |
SANTAP_STATE |
INTEGER |
— |
Decsribes the SANTAP state. |
Table 1-43 MODEL_TYPE Field Description in HW_CARD Table
|
|
1 |
9500 supervisor |
2 |
9500 redundant supervisor |
3 |
9500 16x 2-Gbps FC Module |
4 |
9500 32x 2-Gbps FC Module |
5 |
9500 32x 2-Gbps FC Services (ILC) |
6 |
9500 8x 1GE IP Storage Services (IPS) |
7 |
Caching Services Module (CSM) |
13 |
9216 16x 2-Gbps FC Module plus supervisor |
18 |
9140 40x 2-Gbps FC Module |
19 |
9120 20x 2-Gbps FC Module |
20 |
Advanced Services Module (ASM) |
21 |
MDS 9216 SAM Module |
22 |
14 FC + 2 GE Multiprotocol Services Module |
23 |
2x10-Gbps FC 10-Gbps FC Module |
24 |
4x GE iSCSI/FCIP Services Module |
27 |
9216i 14 FC + 2 IPS, plus supervisor |
28 |
Supervisor-2, supervisor or fabric module |
29 |
12-port FC switching module |
30 |
24-port FC switching module |
31 |
48-port FC switching module |
32 |
4-port 10G FC module |
33 |
Crossbar module on the back of 13-slot chassis |
35 |
9124 24x 4-Gbps FC Module plus supervisor |
36 |
20-port FC switching module for IBM BladeCenter |
37 |
24-port FC switching module for HP c-Class BladeSystem |
39 |
18x 1/2/4G FC + 4x GE module |
40 |
32x 1/2/4G FC + 2x 10 G FC + supervisor module |
41 |
18x 1/2/4G FC + 4x 10 GE + supervisor module |
42 |
48-port 1/2/4/8G 48-Gbps FC module |
43 |
48-port 1/2/4/8G 96-Gbps FC module |
44 |
16 GE port Storage Service Module |
45 |
Cisco MDS 9513 Fabric Module 2 |
46 |
24-port 1/2/4/8G 48-Gbps FC module |
49 |
8-Gb Fabric Switch for HP BladeSystem c-Class |
51 |
48-port 1/2/4/8 Gbps FC/Supervisor-2 9148 module |
56 |
Supervisor-2A, Supervisor/fabric module with 2 GB RAM |
254 |
9020 20-port 4-Gbps FC |
Table 1-44 OPER_STATUS Field Description in HW_CARD Table
|
|
1 |
unknown |
2 |
OK |
3 |
disabled |
4 |
OK but diagnostic failed |
5 |
boot |
6 |
self-test |
7 |
failed |
8 |
missing |
9 |
mismatched parenthesis |
10 |
mismatched configuration |
11 |
diagnostic failed |
12 |
dormant |
13 |
out of service administration |
14 |
out of service environmental temperature |
15 |
powered down |
16 |
powered up |
17 |
power denied |
18 |
power cycled |
19 |
OK but power over warning |
20 |
OK but power over critical |
21 |
sync in progress |
HW_COMPONENT
This table describes the hardware components of a switch, including the model number, the manufacturer, and the revision. Use the SWITCH_ID to associate each hardware component to a switch in the SWITCH table. Table 1-45 describes the HW_COMPONENT database schema table.
Table 1-45 HW_COMPONENT
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the hardware component. |
SWITCH_ID |
INTEGER |
— |
Provides the ID of the parent switch. |
NAME |
VARCHAR2(256) |
— |
Describes the name of the hardware component. |
PHYSICAL_INDEX |
INTEGER |
— |
Describes the value that when combined with the switch card offset yields the relative slot number. |
RELATIVE_POSITION |
INTEGER |
— |
Describes the relative position of the hardware component; for a card, it is the slot number. |
HW_TYPE |
INTEGER |
— |
Describes the type of the hardware component: 1 = other 2 = unknown 3 = chassis 4 = backplane 5 = container 6 = power supply 7 = fan 8 = sensor 9 = module 10 = port 11 = stack |
VENDOR_TYPE |
RAW(200) |
— |
Provides the vendor type of the hardware component. |
HW_REVISION |
VARCHAR2(256) |
— |
Provides the hardware revision of the hardware component. |
FW_REVISION |
VARCHAR2(256) |
— |
Provides the firmware revision of the hardware component. |
SW_REVISION |
VARCHAR2(256) |
— |
Provides the software revision of the hardware component. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Provides the serial number of the hardware component. |
MANUFACTURER |
VARCHAR2(256) |
— |
Provides the manufacturer of the hardware component. |
MODEL_NAME |
VARCHAR2(256) |
— |
Provides the model name of the hardware component. |
ASSET_ID |
VARCHAR2(256) |
— |
Provides the asset ID of the hardware component. |
STATUS_DESCRIPTION |
VARCHAR2(256) |
— |
Provides the status description of the hardware component. |
SEC_SERIAL_NUMBER |
VARCHAR2(256) |
|
Provides the secondary serial number of the hardware component. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
HW_POWER_SUPPLY
This table provides the status on power supplies in an enclosure. Use the HW_COMPONENT_ID to associate an entry with a hardware component in the HW_COMPONENT table. Table 1-46 describes the HW_POWER_SUPPLY database schema table.
Table 1-46 HW_POWER_SUPPLY
|
|
|
|
HW_COMPONENT_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the HW_COMPONENT table. |
REDUNDANCY_MODE |
INTEGER |
— |
Describes the redundancy mode: 1 = not supported 2 = redundant 3 = combined Refer to CISCO-ENTITY-FRU-CONTROL-MIB for more information. |
TOTAL_DRAWN_CURRENT |
INTEGER |
— |
Provides the total current drawn by the power supply. |
TOTAL_AVAILABLE_CURRENT |
INTEGER |
— |
Provides the total current available for the power supply. |
POWER_UNITS |
VARCHAR2(256) |
— |
Provides the units of the power supply. |
ISL
This table describes an ISL that links two ports. Use the PORT1_ID and the PORT2_ID to associate these ports to a port in the SWITCH_PORT table. If this ISL is a PortChannel member, the CHANNEL_ID refers to the parent channel ID. Table 1-47 describes the ISL database schema table.
Table 1-47 ISL Cisco DCNM for SAN Database Schema Table
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the ISL entry in the table. |
PORT1_ID |
INTEGER |
— |
Provides the ID of port1 (the port with smaller WWN). |
PORT2_ID |
INTEGER |
— |
Provides the ID of port2. |
OPER_MODE |
SMALLINT |
— |
Describes the operational mode of the link by port type: 1 = auto 2 = F 3 = FL 4 = E 5 = B 6 = FX 7 = SD 8 = TL 9 = N 10 = NL 11 = NX 12 = TE 13 = FV 14 = down 15 = ST |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the ISL is present in the current fabric. |
STATUS |
SMALLINT |
— |
Deprecated. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes if OPER_MODE is MODE_DOWN, the value is the down status. |
OPER_STATUS_DESCRIPTION |
VARCHAR2(256) |
— |
Describes if OPER_MODE is MODE_DOWN, the value is the down status description. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds since 1/1/1970. |
CHANNEL_CONFIG_CHILD_COUNT |
INTEGER |
— |
Provides the configured PortChannel member count. |
CHANNEL_CURRENT_CHILD_COUNT |
INTEGER |
— |
Provides the PortChannel member count. |
AUTO_CREATED |
NUMBER(1) |
— |
Indicates whether the entry was automatically created. |
IS_CHANNELMEMBER |
NUMBER(1) |
— |
Indicates whether the ISL is a PortChannel member. |
CHANNEL_ID |
INTEGER |
— |
Describes when the ISL is a PortChannel member, the parent channel ID. |
IF_INDEX_1 |
INTEGER |
— |
IF index of the switch port at one end. |
IF_INDEX_2 |
INTEGER |
— |
IF index of the switch port at the other end. |
FICON_ADDRESS_1 |
INTEGER |
— |
Provides the FICON address of the switch port at one end. |
FICON_ADDRESS_2 |
INTEGER |
— |
Provides the FICON address of the switch port at the other end. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
FCSP_AUTHNTICATED |
NUMBER(1) |
— |
Describes if the FCSP is autheticated. |
ESP_SECURED |
NUMBER(1) |
— |
Describes if the ESP is secured. |
ESP_READY |
NUMBER(1) |
— |
Describes if the ESP is ready. |
LICENSE
This table describes licenses configured and in use in a switch. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-48 describes the LICENSE database schema table.
Table 1-48 LICENSE
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the license. |
SWITCH_ID |
INTEGER |
— |
Provides the ID of the switch where the license was installed. |
FEATURE_NAME |
VARCHAR2(256) |
— |
Provides the name of the license. |
TYPE |
INTEGER |
— |
Deprecated. |
LICENSE_FLAG |
RAW(100) |
— |
Provides the license flag that indicates the type of the license: 0 = demo 1 = permanent 2 = counted 3 = unlicensed 4 = in grace period |
MAX_LICENSE |
INTEGER |
— |
Describes the maximum number of licenses. |
MISSING_LICENSE |
INTEGER |
— |
Describes the number of missing licenses. |
CURRENT_LICENSE |
INTEGER |
— |
Describes the number of current licenses. |
EXPIRE |
INTEGER |
DEFAULT -1 |
Describes the expiration time of the license, in milliseconds. |
GRACE_PERIOD |
INTEGER |
— |
Describes the grace period of the license, in seconds. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR29256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
NTOP
This table describes a configured NTOP enity. Table 1-49 describes the NTOP database schema table.
Table 1-49 NTOP
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
IP_ADDR |
VARCHAR2(256) |
— |
Describes the switch IP address. |
PORT_NUMBER |
INTEGER |
— |
Describes the switch port number. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
NTOP_SPAN_INFO
This table associates an NTOP entity with a SPAN port. Use the SPAN_PORT_ID to associate an entry with a SPAN port in the SPAN_PORT table. Table 1-50 describes the NTOP_SPAN_INFO database schema table.
Table 1-50 NTOP_SPAN_INFO
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
NTOP_ID |
INTEGER |
— |
Describes the foreign key to the NTOP table. |
SPAN_PORT_ID |
INTEGER |
— |
Describes the foreign key to the SPAN_PORT table. |
ETH_NAME |
VARCHAR29256) |
— |
Describes the Ethernet port name. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
NPV_LINK
This table describes the N port virtualization link information. Table 1-51 describes the NPV_LINK database schema table.
Table 1-51 NPV_LINK
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
CORE_SWITCH_ID |
INTEGER |
— |
Provides the ID of the core switch. |
NP_SWITCH_ID |
INTEGER |
— |
Provides the ID of the NP switch. |
F_PORT_INDEX |
INTEGER |
— |
Provides the index of the F port. |
NP_PORT_INDEX |
INTEGER |
— |
Provides the index of the NP port. |
F_WWN |
RAW(8) |
— |
Provides the world wide name for log in device F port. |
NP_WWN |
RAW(8) |
— |
Provides the world wide name for log in device NP port. |
OPER_STATUS_CAUSE |
INTEGER |
— |
Describes the operation status cause. |
SPEED |
INTEGER |
— |
Describes the speed. |
IS_PRESENT |
NUMBER(1) |
— |
Describes whether the link is present. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
CHANNEL_CONFIG_CHILD_COUNT |
INTEGER |
— |
Describes the number of child counts. |
CHANNEL_CURRENT_CHILD_COUNT |
INTEGER |
— |
Describes the number of current child counts of the channel. |
AUTO_CREATED |
NUMBER(1) |
— |
Describes whether the NPV link is autocreated. |
IS_CHANNELMEMBER |
NUMBER(1) |
— |
Describes whether the link is channel member. |
CHANNEL_ID |
INTEGER |
— |
Provides the ID of the channel. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
PMDATAINDEX
This table maintains the logical-to-physical mapping of RRD files. Table 1-52 describes the PMDATAINDEX database schema table.
Table 1-52 PMDATAINDEX
|
|
|
|
ID |
INTEGER |
— |
Provides the ID of the entry. |
LOGICALFILENAME |
VARCHAR2(256) |
— |
Provides the logical RRD filename. |
FILETYPE |
INTEGER |
— |
File type has one of the following values: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet |
DATAINDEX |
INTEGER |
— |
Provides the RRD data source index. |
PHYSICLFILEINDEX |
INTEGER |
— |
Provides the physical file index. |
PMEXTRAOID
This table defines object IDs and switch IPs for the Performance Manager data collection. Table 1-53 describes the PMEXTRAOID database schema table.
Table 1-53 PMEXTRAOID
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the record ID. |
FID |
INTEGER |
— |
Provides the fabric ID. |
NAME |
VARCHAR2(256) |
— |
Provides the Performance Manager object ID. |
DISPLAYNAME |
VARCHAR2(256) |
— |
Displays the name used in Web Client. |
SWITCHIP |
VARCHAR2(256) |
— |
Provides the IP address of the switch. |
TYPE |
VARCHAR2(256) |
— |
RRD data source type has one of the following character values: COUNT ABSOLUTE GAUGE |
SWITCHNAME |
VARCHAR2(256) |
— |
Describes the switch name. |
PMINDEXBOOKMARK
This table maintains the current bookmark index of the RRD files. Table 1-54 describes the PMINDEXBOOKMARK database schema table.
Table 1-54 PMINDEXBOOKMARK
|
|
|
|
TYPE |
INTEGER |
NOT NULL PRIMARY KEY |
File type has one of the following values: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet |
BOOKMARKINDEX |
INTEGER |
— |
Provides the current RRD file bookmark index. |
BOOKMARKCOUNT |
INTEGER |
— |
Provides the number of bookmarks. |
SERVERID |
INTEGER |
PRIMARY KEY |
Provides the ID of the server. |
PM_COLLECTION
This table describes a Performance Manager collection. Use the FABRIC_ID to associate this collection to a fabric in the FABRIC table. Table 1-55 describes the PM_COLLECTION database schema table.
Table 1-55 PM_COLLECTION
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry. |
FABRIC_ID |
INTEGER |
— |
Provides the fabric ID; foreign key to a fabric table. |
VSAN_LIST |
VARCHAR2(256) |
— |
Provides the list of VSANs; for example, “1,5,6,4001.” |
MONITOR_ISL |
NUMBER(1) |
— |
Describes whether to collect ISL PM for the fabric. |
MONITOR_HOST |
NUMBER(1) |
— |
Describes whether to collect host PM for the fabric. |
MONITOR_STORAGE |
NUMBER(1) |
— |
Describes whether to collect storage PM for the fabric. |
MONITOR_FLOW |
NUMBER(1) |
— |
Describes whether to collect flow PM for the fabric. |
MONITOR_GIGE |
NUMBER(1) |
— |
Describes whether to collect gigabit Ethernet port PM for the fabric. |
MONITOR_OTHER |
NUMBER(1) |
— |
Describes whether to collect other customized PM for the fabric. |
TRAFFIC_THRESHOLD_ENABLE |
NUMBER(1) |
— |
Describes whether threshold checking on traffic is enabled. |
EVENT_THRESHOLD |
NUMBER(1) |
— |
Describes whether threshold checking on event is enabled. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
PM_OPTION
This table provides threshold details for a Performance Manager collection. Use the ID to associate these details with a Performance Manager collection in the PM_COLLECTION table. Table 1-56 describes the PM_OPTION database schema table.
Table 1-56 PM_OPTION
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of entry. |
AUTO_COLLECT_NEW_DEVICE |
NUMBER(1) |
— |
Describes whether to automatically collect new device PM. |
INTERPOLATION |
NUMBER(1) |
— |
When TRUE, interpolate missing gap in data collection. |
THRESHOLD_TYPE |
INTEGER |
— |
Threshold type: 0 = no threshold checking 1 = static threshold checking Any other value will cause threshold checking using a baseline from historic data. |
CRITICAL_WATERMARK |
INTEGER |
— |
Critical watermark. If traffic exceeds this percentage of the capacity or average traffic, a critical event is triggered. If the BASELINE_PERIOD is 0, the percentage value relates to the capacity. If the BASELINE_PERIOD is nonzero, the percentage value relates to the average for the baseline period. For example, if the BASELINE_PERIOD is 0, 80 indicates that if traffic exceeds 80% of the capacity, then a critical event is triggered. |
WARNING_WATERMARK |
INTEGER |
— |
Warning watermark. If traffic exceeds this percentage of the capacity or average traffic, a warning event is triggered. If the BASELINE_PERIOD is 0, the percentage value relates to the capacity. If the BASELINE_PERIOD is nonzero, the percentage value relates to the average for the baseline period. For example, if the BASELINE_PERIOD is 3, 150 indicates that if traffic exceeds 150% of the average for 3 days, a warning event is triggered. |
BASELINE_PERIOD |
INTEGER |
— |
Baseline period used in threshold checking. If the BASELINE_PERIOD is 0, use static threshold checking that is based on the capacity of the link. Otherwise, use the history specified in days. For example, 7 uses the last 7 days of data history. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
FIVE_MIN_SAMPLE_DAYS |
INTEGER |
DEFAULT 600 |
Provides the number of days to collect samples at 5-minute intervals. |
THIRTY_MIN_SAMPLE_DAYS |
INTEGER |
DEFAULT 700 |
Provides the number of days to collect samples at 30-minute intervals. |
TWO_HOUR_SAMPLE_DAYS |
INTEGER |
DEFAULT 775 |
Provides the number of days to collect samples at 2-hour intervals. |
DAILY_SAMPLE_DAYS |
INTEGER |
DEFAULT 300 |
Provides the number of days to collect samples at daily intervals. |
ISL_INTERVAL |
INTEGER |
DEFAULT 300 |
Collection interval in seconds for ISL objects: 30, 60, 90, up to 300. |
ROLE
This table describes the available role types for each user. Table 1-57 describes the ROLE database schema table.
Table 1-57 ROLE
|
|
|
|
ROLE_NAME |
VARCHAR2(256) |
NOT NULL PRIMARY KEY |
Describes the role name of the user. |
DESCRIPTION |
VARCHAR2(256) |
|
Describes each users role. |
ROLE_FABRIC_INFO
This table describes the role types associated with each fabric and also describes the time when it was last updated. Table 1-58 describes the ROLE_FABRIC_INFO database schema table.
Table 1-58 ROLE_FABRIC_INFO
|
|
|
|
ROLE_NAME |
VARCHAR2(256) |
NOT NULL PRIMARY KEY |
Describes the role name of the user. |
FABRIC_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the fabric. |
LAST_UPDATE_TIME |
TIMESTAMP |
|
Provides the time when the entry was updated. |
SCSI_TARGET
This table provides the WWN for a SCSI target. Use the ID to associate this SCSI target to a port in the SWITCH_PORT table. Table 1-59 describes the SCSI_TARGET database schema table.
Table 1-59 SCSI_TARGET
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the SCSI target. |
WWN |
RAW(8) |
— |
Provides the WWN of the SCSI target. |
ENCLOSURE_ID |
INTEGER |
— |
Provides the ID of the enclosure containing the target. |
DEV_TYPE |
INTEGER |
— |
Device type of the SCSI target: 0 = disk 1 = sequential 2 = printer 3 = processor 4 = WORM 5 = CDROM 6 = scanner 7 = optical 8 = changer 9 = SCSI network 10 = SCSI ASCIT8 11 = SCSI ASCIT8 12 = SCSI array 13 = SCSI enclosure 14 = SCSI RBC |
VENDOR_ID |
VARCHAR2(256) |
— |
Provides the vendor ID of the SCSI target. |
PRODUCT_ID |
VARCHAR2(256) |
— |
Provides the product ID of the SCSI target. |
REV_LEVEL |
VARCHAR2(256) |
— |
Provides the product revision level of the SCSI target. |
OTHER_INFO |
RAW(100) |
— |
Bytes from 0 to 7 in the INQUIRY command response data. |
IS_PRESENT |
NUMBER(1) |
— |
Describes whether the SCSI target exists. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
STATUS |
INTEGER |
— |
Deprecated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
SEQUENCE
This table describes the current long values for automatically generated IDs. Table 1-60 describes the SEQUENCE database schema table.
Table 1-60 SEQUENCE
|
|
|
|
ID |
SMALLINT |
NOT NULL PRIMARY KEY |
Provides the catalog of IDs. |
VALUE |
INTEGER |
— |
Describes the starting value of database IDs. |
SME_SETTINGS
This table describes the SME settings information. Table 1-61 describes the SME_SETTINGS database schema table.
Table 1-61 SME_SETTINGS
|
|
|
|
NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the name of the SME. |
VALUE |
VARCHAR2(64) |
— |
Describes the SME settings value. |
SME_CLUSTER
This table describes the SME cluster information. Table 1-62 describes the SME_CLUSTER database schema table.
Table 1-62 SME_CLUSTER
|
|
|
|
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the name of the cluster. |
CLUSTER_ID |
VARCHAR2(64) |
— |
Provides the ID of the cluster. |
STATUS |
INTEGER |
— |
Provides the status of the SME cluster. |
CKMC_STATE |
INTEGER |
— |
Provides the state of the KMC server. |
MASTER_IP_ADDR |
VARCHAR2(32) |
— |
Describes the IP address of the master switch. |
KMC_ID |
VARCHAR2(32) |
— |
Provides the ID of the KMC. |
SME_CLUSTER_ATTRIBUTES
This table describes the SME cluster attributes information. Table 1-63 describes the SME_CLUSTER_ATTRIBUTES database schema table.
Table 1-63 SME_CLUSTER_ATTRIBUTES
|
|
|
|
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the name of the cluster. |
SECURITY_MODE |
INTEGER |
— |
Describes the security mode for the cluster. |
RECOVERY_THRESHOLD |
INTEGER |
— |
Describes the recovery threshold of the cluster. |
RECOVERY_TOTAL |
INTEGER |
— |
Describes the recovery total of the cluster. |
SME_CLUSTER_SMARTCARD
This table describes the SME cluster SmartCard information. Table 1-64 describes the SME_CLUSTER_SMARTCARD database schema table.
Table 1-64 SME_CLUSTER_SMARTCARD
|
|
|
|
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the name of the cluster. |
MASTER_KEY_GUID |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the master key for the GUID. |
MASTER_KEY_VERSION |
VARCHAR2(8) |
NOT NULL PRIMARY KEY |
Describes the master key version. |
RECOVERY_SHARE_VERSION |
VARCHAR2(8) |
NOT NULL PRIMARY KEY |
Describes the recovery share version. |
SHARE_INDEX |
INTEGER |
— |
Describes the share index. |
SMARTCARD_LAABEL |
VARCHAR2(32) |
— |
Describes the SmartCard label. |
SMARTCARD_SERIAL_NUMBER |
VARCHAR2(32) |
— |
Describes the SmartCard serial number. |
RO_USERNAME |
VARCHAR2(32) |
— |
Describes the role username. |
SME_TAPE_GROUP
This table describes the SME tape group information. Table 1-65 describes the SME_TAPE_GROUP database schema table.
Table 1-65 SME_TAPE_GROUP
|
|
|
|
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the name of the cluster. |
TAPEGROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the tape group name. |
VOLUME_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the volume group name. |
STATUS |
INTEGER |
— |
Describes the status of the tape. |
SME_TAPE_VOLUMEGROUP
This table describes the SME tape volume group information. Table 1-66 describes the SME_TAPE_VOLUMEGROUP database schema table.
Table 1-66 SME_TAPE_VOLUMEGROUP
|
|
|
|
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the name of the cluster. |
TAPEGROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the tape group name. |
VOLUME_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the volume group name. |
STATUS |
INTEGER |
— |
Describes the status of the tape. |
SME_KEY
This table describes the SME key information. Table 1-67 describes the SME_KEY database schema table.
Table 1-67 SME_KEY
|
|
|
|
GUID |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the global unique ID for the key. |
CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Provides the name of the cluster. |
CLONED_FROM_GUID |
VARCHAR2(64) |
— |
Describes whether this is a clone. |
CLUSTER_ID |
VARCHAR2(64) |
— |
ID of the cluster. |
STATUS |
INTEGER |
— |
Describes the status of the key. |
KEY_TYPE |
INTEGER |
— |
Describes the key type of the SME. |
ENTITY_INDEX |
VARCHAR2(256) |
— |
Describes the entity index. |
VERSION |
INTEGER |
— |
Provides the version of the SME. |
WRAP_BY_GUID |
VARCHAR2(64) |
— |
Describes the value wrapped by GUID. |
KEY_DAT |
VARCHAR2(2048) |
— |
Describes the key data. |
MASTER_KEY_GUID |
VARCHAR2(64) |
— |
Describes the master key GUID. |
CREATION_TIME |
TIMESTAMP |
— |
Provides the SME creation time. |
ARCHIVAL_TIME |
TIMESTAMP |
— |
Provides the SME archival time. |
SME_ACCOUNTING_LOG
This table describes the SME accounting log information. Table 1-68 describes the SME_ACCOUNTING_LOG database schema table.
Table 1-68 SME_ACCOUNTING_LOG
|
|
|
|
LOG_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the SME log. |
FIRST_SEEN |
|
|
Describes when the log was first seen. |
TIME_STAMP |
TIMESTAMP |
NOT NULL |
Describes the timestamp. |
HOST_NAME |
VARCHAR2(64) |
NOT NULL |
Describes the name of the host. |
USER_NAME |
VARCHAR2(256) |
— |
Username encrypted for security. |
CLUSTER_NAME |
VARCHAR2(64) |
— |
Describes the name of the cluster. |
CLUSTER_ID |
VARCHAR2(64) |
— |
ID of the cluster. |
OPERATION |
VARCHAR2(64) |
— |
Describes the operation performed. |
STATUS |
VARCHAR2(64) |
— |
Describes the status. |
DETAILS |
VARCHAR2(1024) |
— |
Provides the details. |
LAST_SEEN |
TIMESTAMP |
— |
Describes when the log was last seen. |
COUNT |
BIGINT |
DEFAULT 0 |
Provides the log count. |
GROUP_ID |
INTEGER |
DEFAULT -1 |
Provides the group ID. |
ACK |
SMALLINT |
DEFAULT 0 |
|
DCTYPE |
SMALLINT |
DEFAULT 0 |
Provides the DCTYPE of the log. |
DCID |
|
|
Provides te DCID of the log. |
SME_REPLICATION_REL
This table describes the SME replication release. Table 1-69 describes the SME_REPLICATION_REL database schema table.
Table 1-69 SME_REPLICATION_REL
|
|
|
|
SRC_CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the SME cluster name. |
SRC_TAPE_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the SME tape group name. |
SRC_VOLUME_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the SME volume group name. |
REPLICATION_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the replication ID. |
STATUS |
INTEGER |
— |
Describes the status of the SME. |
CREATION_TIME |
TIMESTAMP, |
— |
Describes the creation time. |
DEST_CLUSTER_NAME |
VARCHAR2(64) |
— |
Provides the destination cluster name. |
DEST_TAPE_GROUP_NAME |
VARCHAR2(64) |
— |
Provides the destination group name. |
DEST_VOLUME_GROUP_NAME |
VARCHAR2(64) |
— |
Provides the destination volume group name. |
STATUS_DESC |
VARCHAR2(255) |
— |
Provides the status description. |
LAST_UPDATE_TIME |
TIMESTAMP, |
— |
Time when the entry was updated. |
SME_REPL_PENDING_KEY
This table describes the SME replication key information. Table 1-70 describes the SME_REPL_PENDING_KEY database schema table.
Table 1-70 SME_REPL_PENDING_KEY
|
|
|
|
GUID |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Global unique ID. |
SRC_CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the SRC cluster name. |
DEST_CLUSTER_NAME |
VARCHAR2(64) |
PRIMARY KEY |
Describes the destination cluster name. |
DEST_TAPE_GROUP_NAME |
VARCHAR2(64) |
PRIMARY KEY |
Describes the destination tape group name. |
DEST_TAPE_VOLUME_GROUP_NAME |
VARCHAR2(64) |
PRIMARY KEY |
Describes the destination tape volume group name. |
SRC_TAPE_GROUP_NAME |
VARCHAR2(64) |
— |
Describes the tape group name. |
SRC_TAPE_VOLUME_GROUP_NAME |
VARCHAR2(64) |
— |
Describes the SRC destination tape volume group name. |
SCHEDULED_REPLICATION_TIME |
TIMESTAMP |
— |
Describes the scheduled replication time. |
SME_REPL_ERROR_KEY
This table describes the SME replication information. Table 1-71 describes the SME_REPL_ERROR_KEY database schema table.
Table 1-71 SME_REPL_ERROR_KEY
|
|
|
|
GUID |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Global unique ID. |
SRC_CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the destination cluster name. |
DEST_CLUSTER_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the destination cluster name. |
DEST_TAPE_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the destination tape group name. |
DEST_VOLUME_GROUP_NAME |
VARCHAR2(64) |
NOT NULL PRIMARY KEY |
Describes the destination tape volume group name. |
SRC_TAPE_GROUP_NAME |
VARCHAR2(64) |
— |
Describes the tape group name. |
SRC_TAPE_VOLUME_GROUP_NAME |
VARCHAR2(64) |
— |
Describes the SRC destination tape volume group name. |
STATUS |
INTEGER |
— |
Describes the status. |
REPLICATION_TIME |
INTEGER |
— |
Provides the replication time. |
STATUS_DESC |
VARCHAR2(255) |
— |
Provides the status description. |
SNMP_COMMUNITY
This table describes an SNMP community. Table 1-72 describes the SNMP_COMMUNITY database schema table.
Table 1-72 SNMP_COMMUNITY
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the SNMP community. |
IP_ADDRESS |
VARCHAR2(256) |
NOT NULL |
Provides the IP address of the community string. |
READ |
VARCHAR2(256) |
— |
Describes the read community string. |
WRITE |
VARCHAR2(256) |
— |
Describes the write community string. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
SNMPUSER
This table describes an SNMP user. Table 1-73 describes the SNMPUSER database schema table.
Table 1-73 SNMPUSER
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the SNMP user. |
VERSION |
INTEGER |
— |
Version of the SNMP user: 1 = SNMPv1 2 = SNMPv2 3 = SNMPv3 |
USER_NAME |
VARCHAR2(256) |
— |
For SNMPv3, the name of the SNMP user. For SNMPv1 or SNMPv2, the community string. |
AUTH_PASSWORD |
VARCHAR2(256) |
— |
Password of the SNMP user; applies to SNMPv3 only. |
PRIV_PASSWORD |
VARCHAR2(256) |
— |
Deprecated. |
AUTH_PROTOCOL |
INTEGER |
— |
Deprecated. |
PRIV_PROTOCOL |
INTEGER |
— |
Deprecated. |
SECURITY_NAME |
VARCHAR2(256) |
— |
Security name of the SNMP user. |
ROLE_NAME |
VARCHAR2(256) |
— |
Describes the role of the SNMP user. |
IS_LOGGING_IN |
NUMBER(1) |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
SPAN_PORT
This table describes a SPAN port on a switch. Use the SWITCH_ID to associate this SPAN port to a switch in the SWITCH table. Table 1-74 describes the SPAN_PORT database schema table.
Table 1-74 SPAN_PORT
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
IF_INDEX |
INTEGER |
— |
Describes the IF index value of the port. |
SWITCH_ID |
INTEGER |
— |
Describes the ID of the parent switch. |
LAST_SCAN_TIME |
INTEGER |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
SPAN_SESSION
This table describes a SPAN session. Use the SPAN_PORT_ID to associate this session to a SPAN port in the SPAN_PORT table. Table 1-75 describes the SPAN_SESSION database schema table.
Table 1-75 SPAN_SESSION
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
SESSION_ID |
INTEGER |
— |
Describes the ID of session. |
SPAN_PORT_ID |
INTEGER |
— |
Describes the foreign key to the SPAN_PORT. |
OPER_STATUS |
INTEGER |
— |
Operation status: 1 = active 2 = inactive |
VSAN_FILTER |
VARCHAR2(256) |
— |
List of VSAN filters, for example, “1,3,5.” |
VSAN_SOURCE |
VARCHAR2(256) |
— |
List of VSAN sources, for example, “1,3,5.” |
LAST_SCAN_TIME |
INTEGER |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
SPAN_SOURCE_PORT
This table describes a SPAN source port. Use the SESSION_ID to associate this source port to a SPAN session in the SPAN_SESSION table. Table 1-76 describes the SPAN_SOURCE_PORT database schema table.
Table 1-76 SPAN_SOURCE_PORT
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the entry. |
IF_INDEX |
INTEGER |
— |
Describes the interface index of the port. |
DIRECTION |
INTEGER |
— |
Direction: receive = 1 transmit = 2 |
SESSION_ID |
INTEGER |
— |
Session ID; foreign key to the SPAN_SESSION. |
LAST_SCAN_TIME |
INTEGER |
— |
Describes the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Describes the time when the entry was updated. |
STATISTICS
This table provides statistics gathered for a Performance Manager collection. Table 1-77 describes the STATISTICS database schema table.
Table 1-77 STATISTICS
|
|
|
|
SRC_ID |
INTEGER |
PRIMARY KEY |
Describes the ID of the source port entry in the SWITCH_PORT table or the END_PORT table. |
DEST_ID |
INTEGER |
PRIMARY KEY |
Describes the ID of the destination port entry in SWITCH_PORT or END_PORT table. |
TYPE |
SMALLINT |
— |
Type of the statistic: 0 = unknown 1 = ISL 2 = flow 3 = initiator 4 = target 5 = other 6 = gigabit Ethernet |
RRD_FILE |
VARCHAR2(256) |
— |
Describes the RRD filename for the entity. |
XML_FILE |
VARCHAR2(256) |
— |
Describes the XML filename for the entity. |
CAPACITY |
INTEGER |
— |
Interface speed of the entity in bytes per second. |
AVG_RX |
BINARY_DOUBLE |
— |
Describes the average number of bytes received per second for the last day. |
AVG_TX |
BINARY_DOUBLE |
— |
Describes the average number of bytes transmitted per second for the last day. |
TOTAL_RXTX |
BINARY_DOUBLE |
— |
Describes the total number of bytes received and transmitted for the last day. |
MAX_RX |
BINARY_DOUBLE |
— |
Describes the peak number of bytes received for the last day. |
MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last day. |
TOTAL_ERR |
BINARY_DOUBLE |
— |
Describes the total number of errors for the last day. |
TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Describes the total number of discards for the last day. |
LAST_WEEK_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last week. |
LAST_WEEK_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last week. |
LAST_WEEK_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Describes the total number of bytes received and transmitted for the last week. |
LAST_WEEK_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last week. |
LAST_WEEK_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last week. |
LAST_WEEK_TOTAL_ERR |
BINARY_DOUBLE |
— |
Describes the total number of errors for the last week. |
LAST_WEEK_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Describes the total number of discards for the last week. |
LAST_MONTH_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last month. |
LAST_MONTH_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last month. |
LAST_MONTH_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Total number of bytes received and transmitted for the last month. |
LAST_MONTH_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last month. |
LAST_MONTH_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last month. |
LAST_MONTH_TOTAL_ERR |
BINARY_DOUBLE |
— |
Total number of errors for the last month. |
LAST_MONTH_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Total number of discards for the last month. |
LAST_YEAR_AVG_RX |
BINARY_DOUBLE |
— |
Average number of bytes received per second for the last year. |
LAST_YEAR_AVG_TX |
BINARY_DOUBLE |
— |
Average number of bytes transmitted per second for the last year. |
LAST_YEAR_TOTAL_RXTX |
BINARY_DOUBLE |
— |
Total number of bytes received and transmitted for the last year. |
LAST_YEAR_MAX_RX |
BINARY_DOUBLE |
— |
Peak number of bytes received for the last year. |
LAST_YEAR_MAX_TX |
BINARY_DOUBLE |
— |
Peak number of bytes transmitted for the last year. |
LAST_YEAR_TOTAL_ERR |
BINARY_DOUBLE |
— |
Total number of errors for the last year. |
LAST_YEAR_TOTAL_DISCARD |
BINARY_DOUBLE |
— |
Total number of discards for the last year. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
LAST_THRESHOLD_EVENT_TIME |
TIMESTAMP |
— |
Last threshold event receive time. |
THRESHOLD_EVENT_COUNT |
SMALLINT |
— |
Threshold event count. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
SWITCH
This table provides the sWWN and fabric ID for a switch. Use the FABRIC_ID to associate each switch to a fabric in the FABRIC table. Table 1-78 describes the SWITCH database schema table.
Table 1-78 SWITCH
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the switch entry in the switch table. |
FABRIC_ID |
INTEGER |
— |
Provides the ID of the parent fabric entry in fabric table. |
LICENSE_ID |
INTEGER |
— |
Deprecated. |
WWN |
RAW(8) |
— |
Provides the WWN of the switch. |
IP_ADDRESS |
RAW(100) |
— |
Provides the IP address of the switch. |
IS_MDS |
NUMBER(1) |
— |
Indicates whether the switch is an MDS switch. |
TYPE |
INTEGER |
— |
Model type of the switch; applies to MDS switches only. See Table 1-79 . |
IS_MANAGABLE |
NUMBER(1) |
— |
Indicates whether the switch is manageable. |
UNMANAGABLE_CAUSE |
VARCHAR2(256) |
— |
Describes the reason why the switch is unmanageable. |
NON_MDS_MODEL |
VARCHAR2(256) |
— |
Model name for a non-MDS switch. |
SYS_NAME |
VARCHAR2(256) |
— |
Provides the system name. |
SYS_CONTACT |
VARCHAR2(256) |
— |
Provides the system contact information. |
SYS_LOCATION |
VARCHAR2(256) |
— |
Provides the system location information. |
SYS_UPTIME |
INTEGER |
— |
Provides the system uptime in hundredths of seconds. 0 indicates system down. |
ACTIVE_SUP_SLOT |
INTEGER |
— |
Provides the active supervisor slot number. |
STANDBY_SUP_STATE |
INTEGER |
— |
Status of the standby supervisor: 1 = unknown 2 = disabled 3 = initialization 4 = negotiation 5 = standby cold 6 = standby cold configuration 7 = standby cold file system 8 = standby cold bulk 9 = standby hot 10 = active fast 11 = active drain 12 = active pre-configuration 13 = active post-configuration 14 = active 15 = active extra load 16 = active handback |
CONN_UNIT_STATUS |
INTEGER |
— |
Connection unit status: 0 = unknown 1 = unused 2 = OK 3 = warning: needs attention 4 = failed |
FEATURE_FLAG |
INTEGER |
— |
Licensed features. Refer to CISCO-FEATURE-CONTROL-MIB for details. |
FEATURES_STRING |
VARCHAR2(256) |
— |
Describes the feature flag value in string format. |
IS_LICENSE_VIOLATION |
NUMBER(1) |
— |
Indicates whether the switch has a license violation. |
VERSION |
VARCHAR2(256) |
— |
Version of the switch. |
IS_PRESENT |
NUMBER(1) |
— |
Indicates whether the switch is present. |
SERIAL_NUMBER |
VARCHAR2(256) |
— |
Serial number of the switch. |
NUM_PORTS |
INTEGER |
— |
Number of Fibre Channel ports in the switch. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
LAST_SCAN_TIME |
INTEGER |
— |
Time when last seen, in milliseconds, since 1/1/1970. |
IS_TRAP_REGISTERED |
NUMBER(1) |
— |
Indication of whether the trap receiver is registered in the switch. |
IS_SYSLOG_REGISTERED |
NUMBER(1) |
— |
Indicate whether the syslog receiver is registered in the switch. |
SYS_DESCRIPTION |
VARCHAR2(256) |
— |
Deprecated. |
VENDOR |
VARCHAR2(256) |
— |
Deprecated. |
FCFE_MODULE_ID |
INTEGER |
— |
Deprecated. |
STANDBY_SUP_SLOT |
INTEGER |
— |
Slot number of the standby supervisor card. |
MODULE_INDEX_OFFSET |
INTEGER |
— |
Module index offset. |
OPER_MODE |
INTEGER |
— |
Describes the operation mode. |
CPU_USAGE |
INTEGER |
— |
Provides the switch supervisor CPU usage. |
MEM_USAGE |
INTEGER |
— |
Provides the switch supervisor memory usage. |
IS_VDC |
NUMBER(1) |
— |
Provides information if this is a VDC. |
VDC_ID |
INTEGER |
— |
Provides the VDC ID. |
VDC_MAC |
RAW(6) |
— |
Provides the MAC address of the VDC. |
VDC_NAME |
VARCHAR2(255) |
— |
Provides the name of the VDC. |
FCOE_CAPABLE |
NUMBER(1) |
— |
Describes if the switch is capable for FCoE. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
Table 1-79 TYPE Field Description in SWITCH Table
|
|
375 |
Cisco MDS 9506 chassis |
376 |
Cisco MDS 9509 chassis |
377 |
Cisco MDS 9513 chassis |
380 |
Cisco MDS 9216 chassis |
411 |
Cisco MDS 9140, 40-port fixed configuration fabric switch chassis |
414 |
Cisco MDS 9120, 20-port fixed configuration fabric switch chassis |
442 |
Cisco MDS 9216A chassis |
472 |
Cisco 2-Slot MDS fabric switch chassis |
475 |
Cisco SN 5428 |
514 |
Cisco MDS 9020-20K9, 20-port 4 Gbps FC fabric switch |
529 |
Cisco SN 5428-2 |
587 |
Cisco MDS 9124 |
601 |
Cisco IBM_BLADE_SERVER |
606 |
Cisco HP_BLADE_SERVER |
612 |
Nexus 7010 switch, 10 slots |
616 |
Cisco MDS 9134 Multilayer Fabric Switch |
651 |
MDS 9222i Multiservice Modular Switch |
719 |
Nexux 5000 series (Eugene) chassis |
773 |
NEC_BLADE_SERVER |
777 |
Nexus 7018 switch, 18 slots |
798 |
Nexus 5000 series (Bend) chassis |
841 |
MDS HUASHAN 9148 FC (1 Slot) Chassis 1/2/4/8 Gbps FC/Supervisor-2 |
843 |
HP Blade System Cassino |
847 |
UCS Springfield chassis 20-port |
899 |
UCS Springfield chassis 40-port |
934 |
Nexux 5000 series (Bend) chassis Dual Core |
935 |
Nexux 5000 series (Eugene) chassis Dual Core |
936 |
Nexux 5000 series (Eugene) 10G Base-T (Sherwood) |
1008 |
Nexux 5000 series (Oxygen) |
SWITCH_MGMT_ADDRESS
This table provides the switch management port IP address. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-80 describes the SWITCH_MGMT_ADDRESS database schema table.
Table 1-80 SWITCH_MGMT_ADDRESS
|
|
|
|
SWITCH_ID |
INTEGER |
NOT NULL |
Provides the ID of the switch. |
MGMT_ADDRESS |
RAW(100) |
— |
Provides the management IP address. |
MGMT_TYPE |
NUMBER(4) |
— |
Deprecated. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
SWITCH_PORT
This table ssociates an SNMP ifIndex and pWWN to a port. Use the SWITCH_ID to associate each entry to a switch in the SWITCH table. Table 1-81 describes the SWITCH_PORT database schema table.
Table 1-81 SWITCH_PORT
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the primary key of the database entry. |
IF_INDEX |
INTEGER |
— |
Interface index of the port. |
SWITCH_ID |
INTEGER |
— |
Provides the ID of the parent switch. |
WWN |
RAW(8) |
— |
WWN of the port. |
FICON_PORT_ADDRESS |
RAW(100) |
— |
FICON address. |
IS_HUB |
NUMBER(1) |
— |
Indication of whether the port is a hub. |
IS_CHANNEL |
NUMBER(1) |
— |
Indication of whether the port belongs to a PortChannel. |
CHANNEL_ID |
INTEGER |
— |
PortChannel ID. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
STATUS |
SMALLINT |
— |
Status of the port. Refer to CISCO-FC-FE-MIB for details. |
IS_SPAN |
NUMBER(1) |
— |
Deprecated. |
PORT_GROUP |
INTEGER |
— |
Port group calculated from the port index; applies only to a 32-port card. |
SLOT |
SMALLINT |
— |
Describes the slot number. |
IF_SPEED |
INTEGER |
— |
Port speed in bits per second. |
IF_NAME |
VARCHAR2(256) |
— |
Port interface name. |
IF_TYPE |
INTEGER |
— |
Port interface type. Refer to values for IANAifType in IANAifType-MIB. |
PARENT |
INTEGER |
— |
Parent. |
CLUSTER_ID |
VARCHAR2(256) |
— |
Describes the cluster ID. |
SME_STATE |
INTEGER |
— |
Describes the SME state. |
IOA_STATE |
INTEGER |
— |
Describes the IOA state. |
IF_CONNTYPE |
INTEGER |
— |
Describes the interface connection type. |
IF_DESCR |
VARCHAR2(256) |
— |
Describes the interface description. |
SLOT |
SMALLINT |
NULL |
Provides the slot on which the port belongs. |
IS_VFC |
NUMBER(1) |
— |
Describes if this is an vFC. |
VFC_BIND_TYPE |
INTEGER |
— |
Describes the vFC bind type. |
VFC_BIND_IFINDEX |
INTEGER |
— |
Describes the interface index that vFC binds. |
VFC_BIND_MAC |
RAW(6) |
— |
Provides the MAC address that vFC binds. |
DISPLAY_NAME |
VARCHAR2(256) |
NULL |
Provides the display name for this object. |
IS_PHYSICAL |
NUMBER(1) |
— |
Describes if this is a physical interface. |
IF_OPERSTATUS |
INTEGER |
— |
Describes the interface operational status. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
IF_DESCR |
VARCHAR2 (256) |
NULL |
|
IOA_STATE |
INTEGER |
— |
|
IS_VFC |
NUMBER(1) |
— |
|
VFC_BIND_TYPE |
SMALLINT |
— |
Provides the VFC bind type. |
VFC_BIND_IFINDEX |
INTEGER |
— |
Provides the VFC bind index. |
VFC_BIND_MAC |
RAW(6) |
— |
Provides the VFC bind MAC address. |
DISPLAY_NAME |
VARCHAR2 (256) |
NULL |
Provides the display name. |
IS_PHYSICAL |
NUMBER(1) |
— |
|
IF_OPERSTATUS |
INTEGER |
— |
Describes the operations status. |
FICON_ADDRESS |
INTEGER |
— |
Provides the FICON address. |
IF_ADMINSTATUS |
SMALLINT |
— |
Describes the administrator status. |
SVR_PROP
This table describes the server properties. Table 1-82 describes the SVR_PROP database schema table.
Table 1-82 SVR_PROP
|
|
|
|
KEY |
VARCHAR2(256) |
PRIMARY KEY |
Describes the server property. |
VALUE |
VARCHAR2(256) |
— |
Describes the server property value. |
VCENTER
This table describes the virtual center. Table 1-83 describes the VCENTER database schema table.
Table 1-83 VCENTER Network Management Table
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the virtual host. |
IP_ADDRESS |
RAW(100) |
— |
Provides the IP address of the virtual host. |
USER_NAME |
VARCHAR2(256) |
— |
Provides the username encrypted for security. |
PASSWORD |
VARCHAR2(256) |
— |
Provides the password encrypted for security. |
DISCOVERY |
NUMBER(1) |
— |
Describes if discovery is a ongoing procedure. |
STATE |
NUMBER(1) |
— |
Describes the discovery status. |
STATUS_DESCRIPTION |
VARCHAR2(256) |
— |
Provides the status description of the hardware component. |
LAST_SCAN_TIME |
INTEGER |
— |
Provides the time when last seen, in milliseconds, since 1/1/1970. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
USERFABRIC
This table describes the user of a fabric. Table 1-84 describes the USERFABRIC_INFO database schema table.
Table 1-84 USERFABRIC Cisco DCNM for SAN Database Schema Table
|
|
|
|
FMUSER_NAME |
VARCHAR2(256) |
NOT NULL PRIMARY KEY |
Provides the name of the Cisco DCNM for SAN user. |
FABRIC_ID1 |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the fabric. |
SNMPUSER_ID |
INTEGER |
— |
Provides the ID of the SNMP user. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
|
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
|
Deprecated. |
USERSWITCH_INFO
This table describes the user switch information. Table 1-85 describes the USERSWITCH_INFO database schema table.
Table 1-85 USERSWITCH_INFO
|
|
|
|
FMUSER_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Describes the ID of the Cisco DCNM for SAN user. |
IP_ADDRESS |
RAW(100) |
NOT NULL PRIMARY KEY |
Describes the IP address of the switch. |
SNMPUSER_ID |
INTEGER |
|
Describes the ID of the SNMP user. |
LAST_UPDATE_TIME |
TIMESTAMP |
|
Time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
|
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
|
Deprecated. |
VSAN
This table describes a VSAN within a fabric. Use the FABRIC_ID to associate this VSAN with a fabric in the FABRIC table. Table 1-86 describes the VSAN database schema table.
Table 1-86 VSAN
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
NAME |
VARCHAR2(256) |
— |
Provides the name of the VSAN. |
IS_UP |
NUMBER(1) |
— |
Indicates whether the VSAN is up. |
IS_DISJOINT |
NUMBER(1) |
— |
Indicates whether the VSAN is segmented. |
SEED_SWITCH_ID |
INTEGER |
— |
Provides the ID of the seed switch. |
ENF_ZONESET_NAME |
VARCHAR2(256) |
— |
Active zone set name. |
ENF_ZONESET_ACTIVATE_TIME |
INTEGER |
— |
Provides the time in milliseconds when the zone set is activated. |
FABRIC_ID |
INTEGER |
— |
Provides the parent fabric ID. |
VSAN_ID1, |
INTEGER |
— |
Provides the VSAN ID. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
PRINCIPAL_SWWN |
RAW(100) |
— |
WWN of the principal switch. |
FICON_STATE |
INTEGER |
— |
FICON state: 0 = non-FICON 1 = offline 2 = online |
INTER_OPER_MODE |
INTEGER |
— |
Interoperation mode of the VSAN: 0 = disabled 1 to 4 = enabled |
PRINCIPAL_SW_ID |
INTEGER |
— |
Provides the ID of the principal switch. |
ADMIN_STATE |
NUMBER(4) |
— |
Administrative state of the VSAN: 1 = active 2 = suspended |
MTU |
INTEGER |
— |
Provides the MTU of the VSAN. |
LOAD_BALANCING_TYPE |
NUMBER(4) |
— |
Type of load balancing used by the VSAN: 1 = source and destination IDs only 2 = source, destination, and originator exchange IDs |
INORDER_DELIVERY |
NUMBER(1) |
— |
Indicates whether in-order delivery is guaranteed. |
NETWORK_DROP_LATENCY |
INTEGER |
— |
Provides the network drop latency in milliseconds. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VSAN_DOMAIN_INFO
This table associates a VSAN with a domain on a swtich. Use the SWITCH_ID to associate this VSAN and domain with a switch in the SWITCH table. Table 1-87 describes the VSAN_DOMAIN_INFO database schema table.
Table 1-87 VSAN_DOMAIN_INFO
|
|
|
|
VSAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the VSAN. |
SWITCH_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the switch. |
DOMAIN_ID |
SMALLINT |
— |
Provides the domain of the switch in the VSAN. |
WWN |
RAW(100) |
— |
Provides the WWN of the switch in the VSAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VSAN_ENDPORT_INFO
This table provides the FCID for an end port in a VSAN. Use the VSAN_ID to associate this end port with a VSAN in the VSAN table. Table 1-88 describes the VSAN_ENDPORT_INFO database schema table.
Table 1-88 VSAN_ENDPORT_INFO
|
|
|
|
VSAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the VSAN. |
ENDPORT_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the end port. |
FCID |
INTEGER |
— |
Provides the FC ID of the end port in the VSAN. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
VSAN_ISL_INFO
This table provides the status for an ISL in a VSAN. Use the VSAN_ID to associate this ISL with a VSAN in the VSAN table. Table 1-89 describes the VSAN_ISL_INFO database schema table.
Table 1-89 VSAN_ISL_INFO
|
|
|
|
VSAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the VSAN. |
ISL_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the ISL. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
XMLDOCS
This table describes the XML documents information. Table 1-90 describes the XMLDOCS database schema table.
Table 1-90 XMLDOCS
|
|
|
|
DOCUMENT_TABLE |
VARCHAR2(256) |
UNIQUE |
Describes the document type. |
USER_NAME |
VARCHAR2(256) |
UNIQUE |
Describes the name of the user. |
CONTENT |
CLOB |
— |
Describes the content of each XML document. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
VSAN_NPVL_INFO
This table describes the VSAN NPVL information. Table 1-91 describes the VSAN_NPVL_INFO database schema table.
Table 1-91 VSAN_NPVL_INFO
|
|
|
|
VSAN_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the VSAN. |
NPVL_ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of NPVL. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
ZONE
This table describes a zone. Use the IS_IVR to determine if this zone is an IVR zone. If it is an IVR zone, use the PARENT_ID to associate this zone with a fabric in the FABRIC table. Otherwise, use the PARENT_ID to associate this zone with a VSAN in the VSAN table. Table 1-92 describes the ZONE database schema table.
Table 1-92 ZONE
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
PARENT_ID |
INTEGER |
— |
Provides the ID of the parent. Parent could be either a fabric (IVR zone) or VSAN. |
IS_IVR |
NUMBER(1) |
— |
Indicates whether the zone is an IVR zone. |
ZONE_INDEX |
INTEGER |
— |
Describes the index of the zone. |
NAME |
VARCHAR2(256) |
— |
Describes the name of the zone. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Indicates the time when the entry was updated. |
READ_ONLY |
NUMBER(1) |
— |
Indicates whether the zone can be modified. |
QOS |
NUMBER(1) |
— |
Indicates whether QoS is supported by the zone. |
QOS_PRIORITY |
INTEGER |
— |
Priority of the LUN: 1 = none 2 = low 3 = medium 4 = high |
BROADCAST |
NUMBER(1) |
— |
Indicates whether the zone supports broadcast. |
CFS_REGION_ID |
INTEGER |
— |
Provides the region ID of the CFS. |
RESERVE_COL1 |
VARCHAR2(256) |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR2(256) |
— |
Deprecated. |
CFS_REGION_ID |
INTEGER |
— |
|
ZONE_MEMBER
This table describes a member of a zone. Use the ZONE_ID to associate this member with a zone in the ZONE table. Table 1-93 describes the ZONE_MEMBER database schema table.
Table 1-93 ZONE_MEMBER
|
|
|
|
ID |
INTEGER |
NOT NULL PRIMARY KEY |
Provides the ID of the entry in the table. |
ZONE_ID |
INTEGER |
— |
Provides the ID of the parent zone. |
TYPE |
INTEGER |
— |
Type of the member: 1 = zone 2 = alias |
MEMBER_ID |
RAW(100) |
— |
Provides the ID of the zone member. |
LUN_ID |
RAW(1000) |
— |
Provides the ID of LUNs. |
LAST_UPDATE_TIME |
TIMESTAMP |
— |
Provides the time when the entry was updated. |
IVR_VSAN_ID |
INTEGER |
— |
Provides the VSAN ID for the IVR zone member. |
PORT_STATUS |
RAW(100) |
— |
Deprecated. |
AFID |
INTEGER |
— |
Provides the AFID of the IVR zone member. |
CFS_REGION_ID |
INTEGER |
— |
Provides the region ID of the CFS. |
RESERVE_COL1 |
VARCHAR |
— |
Deprecated. |
RESERVE_COL2 |
VARCHAR |
— |
Deprecated. |
ENDPORT_ID |
INTEGER |
— |
Provides the endport ID. |
SWITCHPORT_ID |
INTEGER |
— |
provides the switchport ID |
NAME |
VARCHAR(256) |
NULL |
Provides the name of the zone member. |
SWITCH_INT |
VARCHAR(256) |
NULL |
|