Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1222 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
MANUFACTURER Manufacturer of the device, typically IBM. varchar 64
MANUFACTURER_PLANT Plant number where the device is manufactured. varchar 64
SEQUENCE_NUMBER Device sequence number. varchar 32
TAG FICON device property, e.g., 809a or 809b. varchar 16
FLAG FICON device property, e.g., 0x10 (hex). varchar 8
PARAMS FICON device property string, e.g., Valid channel port. varchar 16
TABLE 135 FIRMWARE_FILE_DETAIL
Field Definition Format Size
ID* Unique generated database identifier. int
FIRMWARE_NAME Name of the firmware file. varchar 64
MAJOR_VERSION Major version bit from the firmware version. smallint
MINOR_VERSION Minor version bit from the firmware version. smallint
MAINTENANCE Maintenance bit from the firmware version. smallint
PATCH Patch bit from the firmware version. varchar 64
PHASE Phase bit from the firmware version. varchar 64
RELEASE_DATE Release date of the firmware file. timestamp
IMPORTED_DATE Imported date of the file to the Management
applciation.
timestamp
FIRMWARE_FILE_SIZE Firmware file size. int
FIRMWARE_LOCATION Firmware file location in the Management applciation
repository.
varchar 1024
RELEASE_NOTES_
LOCATION
Release notes file location in theManagement
applciation repository.
varchar 1024
FIRMWARE_REPOSITORY_
TYPE
Repository type to identify the FTP server:
0 = internal FTP.
1 = external FTP.
smallint
TABLE 136 FIRMWARE_SWITCH_DETAIL
Field Definition Format Size
FIRMWARE_ID* ID for the firmware file. int
SWITCH_TYPE* Switch type that supports this firmware file. smallint
REBOOT_REQUIRED Reboot required flag for the switch type. smallint
NUMFILES Number of files in the firmware. int
TABLE 134 FICON_DEVICE_PORT (Continued)
Field Definition Format Size