MEDIA_RECORDS

Information on volume types for database-specific files. The current authorization identifier must have the UTILITY privilege for the database.

Column name	Data type	Contents
MEDIA_CATALOG	CHAR (18)	Database name
FILE_TYPE	CHAR (6)	File type: DALOG CATLOG PBI CATREC DDLTA
DEVICE_DESCRIPTOR	CHAR (18)	Device type or name of the storage group for the file
MEDIUM	CHAR (4)	DISC
ORDINAL_POSITION	SMALLINT	Sequence number of the entry in the media table

Table 78: MEDIA_RECORDS view of the INFORMATION_SCHEMA