MEDIA_DESCRIPTIONS

Information on file attributes 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
REQUESTS	VARCHAR (3)	YES Volume can be requested at console NO Volume cannot be requested at console
PRIMARY_ALLOC	INTEGER	Primary allocation
SECONDARY_ALLOC	INTEGER	Secondary allocation
SHARABLE	VARCHAR (3)	File sharable: YES NO

Table 77: MEDIA_DESCRIPTIONS view of the INFORMATION_SCHEMA