Brocade Communications Systems IP250 Database tables and fields Featuresusage, Ficondeviceport

	Database tables and fields		I
TABLE 146 FEATURES_USAGE (Continued)
Field	Definition	Format	Size
USAGE_COUNT	Count shows how many times the feature is	int
	accessed.
FIRST_UPDATED_TIME	Identifies the first updated time stamp.	timestamp
TABLE 147 FICON_DEVICE_PORT
Field	Definition	Format	Size
DEVICE_PORT_ID*	Value for the device port to which these FICON	int
	properties are applied.
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 148 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	timestamp
	application.
FIRMWARE_FILE_SIZE	Firmware file size.	int
FIRMWARE_LOCATION	Firmware file location in the Management application	varchar	1024
	repository.
RELEASE_NOTES_	Release notes file location in theManagement	varchar	1024
LOCATION	application repository.
FIRMWARE_REPOSITORY_	Repository type to identify the FTP server:	smallint
TYPE	0 = internal FTP.
	1 = external FTP.

Brocade Network Advisor IP User Manual	1441
53-1003056-01