Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1643 / 1940

Brocade Network Advisor SAN User Manual 1591
53-1003154-01
Database tables and fields
H
USAGE_COUNT Count shows how many times the feature is
accessed. int
FIRST_UPDATED_TIME Identifies the first updated time stamp. timestamp
TABLE 150
FICON_DEVICE_PORT
Field Definition Format Size
DEVICE_PORT_ID* Value for the device port to which these FICON
properties are applied. int
TYPE_NUMBER varchar 16
MODEL_NUMBER Ficon device model number, such as S18. varchar 64
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 151
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
application. timestamp
FIRMWARE_FILE_SIZE Firmware file size. int
FIRMWARE_LOCATION Firmware file location in the Management application
repository. varchar 1024
RELEASE_NOTES_
LOCATION Release notes file location in theManagement
application repository. varchar 1024
FIRMWARE_REPOSITORY_
TYPE Repository type to identify the FTP server:
0 = internal FTP.
1 = external FTP. smallint
TABLE 149 FEATURES_USAGE (Continued)
Field Definition Format Size