QUSRBRM.MAINTENANCE_POLICY View

The QUSRBRM.MAINTENANCE_POLICY view returns a single row that shows the settings to be used when STRMNTBRM is run by a control group backup.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/MAINT_PCY object.

Result Table

The following table describes the columns in the view. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
EXPIRE_MEDIA	EXPMEDIA	CHAR(3)	Specifies if media should be expired. The possible values are: NO Media will not be expired. YES Media will be expired.
EXPIRE_PARTIAL_SET	EXPPARTSET	CHAR(3)	Specifies if partial sets should be expired. The possible values are: NO Partial sets will not be expired. YES Partial sets will be expired.
REMOVE_MEDIA_INFO	RMVMEDINF	CHAR(7)	Specifies which information should be removed from the BRMS media content inventory. The possible values are: NONE No Media information will be removed. EXPIRED Media information for expired media will be removed. REUSED Media information for reused media will be removed.
RETAIN_OBJECT_DETAIL	RTNOBJDTL	CHAR(6)	Specifies the number of days to keep object level detail. The possible values are: MEDCON Object level detail is removed when media content information is removed. 1 - 9999 Specify the number of days that object level detail is kept in the media content inventory.
RETAIN_LINK_DETAIL	RTNLNKDTL	CHAR(6)	Specifies the number of days to keep link level detail. The possible values are: MEDCON Link level detail is removed when media content information is removed. 1 - 9999 Specify the number of days that link level detail is kept in the media content inventory.
RETAIN_SPLF_DETAIL	RTNSPLFDTL	CHAR(6)	Specifies the number of days to keep spooled file level detail. The possible values are: MEDCON Spooled file level detail is removed when media content information is removed. 1 - 9999 Specify the number of days that spooled file level detail is kept in the media content inventory.
RETAIN_FOLDER_DETAIL	RTNFLRDTL	CHAR(6)	Specifies the number of days to keep folder level detail. The possible values are: MEDCON Folder level detail is removed when media content information is removed. 1 - 9999 Specify the number of days that folder level detail is kept in the media content inventory.
REMOVE_MIGRATION_INFO	RTNMGRINFO	CHAR(6)	Specifies how old in number of days that migration information should be before it is removed. The possible values are: NONE Migration information is not removed. 1 - 9999 Specify the number of days after which migration information is removed.
RUN_MOVE_POLICIES	RUNMOVPCY	CHAR(3)	Specifies if move policies should be run. The possible values are: NO Move policies will not be run. YES Move policies will be run.
LOG_ENTRIES_DAYS	LOGENTDAYS	SMALLINT	Specifies how old in number of days that log entries should be before they are removed. The possible values are: 1 - 99999 Specify the number of days after which log entries are removed.
RUN_CLEANUP	RUNCLEANUP	CHAR(3)	Specifies if clean up should be run. The possible values are: NO Cleanup will not be run. YES Cleanup will be run.
RETRIEVE_VOLUME_STATS	RTVVOLSTAT	CHAR(3)	Specifies if volume statistics should be retrieved. The possible values are: NO Volume statistics will not be retrieved. YES Volume statistics will be retrieved.
MEDIA_AUDIT	MEDAUDIT	CHAR(3)	Specifies if shared media attributes should be audited. The possible values are: NO Shared media attributes will not be audited. YES Shared media attributes will be audited.
CHANGE_JOURNALS	CHGJRNS	CHAR(3)	Specifies if the receivers for the BRMS journals should be changed. The possible values are: NO Receivers for the BRMS journals will not be changed. YES Receivers for the BRMS journals will be changed.
EXPIRED_MEDIA_REPORT	EXPMEDRPT	CHAR(3)	Specifies if the expired media report should be run. The possible values are: NO The expired media report will not be run. YES The expired media report will be run.
VERSION_REPORT	VERRPT	CHAR(3)	Specifies if the version control report should be run. The possible values are: NO The version control report will not be run. YES The version control report will be run.
MEDIA_INFO_REPORT	MEDINFRPT	CHAR(3)	Specifies if the media info report should be run. The possible values are: NO The media info report will not be run. YES The media info report will be run.
RECOVERY_ACTIVITIES_REPORT	RCYACTRPT	CHAR(3)	Specifies if the recovery activities report should be run. The possible values are: NO The recovery activities report will not be run. YES The recovery activities report will be run.
SYSTEM_RECOVERY_REPORT	SYSRCYRPT	CHAR(3)	Specifies if the recovery analysis report should be run. The possible values are: NO The recovery analysis report will not be run. YES The recovery analysis report will be run.
SAVE_EXCEPTIONS_REPORT	SAVEXCRPT	CHAR(3)	Specifies if the save strategy exceptions report should be run. The possible values are: NO The save strategy exceptions report will not be run. YES The save strategy exceptions report will be run.
SYSTEM_INFO_REPORT	SYSINFRPT	CHAR(3)	Specifies if the PRTSYSINF command should be run. The possible values are: NO The PRTSYSINF command will not be run. YES The PRTSYSINF command will be run.

Examples:

View all maintenance policy values:

SELECT * FROM QUSRBRM.MAINTENANCE_POLICY;

View all ‘retain detail’ maintenance policy values:

SELECT RETAIN_OBJECT_DETAIL, RETAIN_LINK_DETAIL, RETAIN_SPLF_DETAIL, RETAIN_FOLDER_DETAIL FROM QUSRBRM.MAINTENANCE_POLICY;