QUSRBRM.CHANGE_MAINTENANCE_POLICY Procedure

Owned by Peter Lafler
Mar 15, 2023
4 min read

The QUSRBRM.CHANGE_MAINTENANCE_POLICY procedure allows you to change the maintenance policy.

Parameters

QUSRBRM.CHANGE_MAINTENANCE_POLICY (EXPIRE_MEDIA=> expire-media, EXPIRE_PARTIAL_SET=> expire-partial-set, REMOVE_MEDIA_INFO=> remove-media-info, RETAIN_OBJECT_DETAIL=> retain-object-detail, RETAIN_LINK_DETAIL=> retain-link-detail, RETAIN_SPLF_DETAIL=> retain-splf-detail, RETAIN_FOLDER_DETAIL=> retain-folder-detail, REMOVE_MIGRATION_INFO=> remove-migration-info, RUN_MOVE_POLICIES=> run-move-policies, LOG_ENTRIES_DAYS=> log-entries-days, RUN_CLEANUP=> run-cleanup, RETRIEVE_VOLUME_STATS=> retrieve-volume-stats, MEDIA_AUDIT=> media-audit, CHANGE_JOURNALS=> change-journals, EXPIRED_MEDIA_REPORT=> expired-media-report, VERSION_REPORT=> version-report, MEDIA_INFO_REPORT=> media-info-report, RECOVERY_ACTIVITIES_REPORT=> recovery-activities-report, SYSTEM_RECOVERY_REPORT=> system-recovery-report, SAVE_EXCEPTIONS_REPORT=> save-exceptions-report, SYSTEM_INFO_REPORT=> system-info-report)

Note: All parameters are optional. If a parameter is not specified, it’s value will not be changed.

expire-media (Optional)

Specifies whether to expire media when the STRMNTBRM command processes.

Possible values are:

NO

Media will not be expired.

YES

Media will be expired.

 

expire-partial-set (Optional)

Specifies whether to expire media set volumes when the STRMNTBRM command processes.

Possible values are:

NO

Volumes in a media set are not expired.

YES

Volumes in a media set are expired.

 

remove-media-info (Optional)

Specifies what information to remove from the BRMS media content inventory when the STRMNTBRM command processes.

Possible values are:

NONE

Media information will not be removed.

EXPIRED

Media information for expired media will be removed.

REUSED

Media information for reused media will be removed.

 

retain-object-detail (Optional)

Specifies the number of days to keep object level detail when the STRMNTBRM command processes.

Possible values are:

MEDCON

Object detail is removed when media content information is removed.

1 - 9999

Specify the number of days that object detail is kept in the media content inventory.

 

retain-link-detail (Optional)

Specifies the number of days to keep link level detail when the STRMNTBRM command processes.

Possible values are:

MEDCON

Link detail is removed when media content information is removed.

1 - 9999

Specify the number of days that link detail is kept in the media content inventory.

 

retain-splf-detail (Optional)

Specifies the number of days to keep spooled file level detail when the STRMNTBRM command processes.

Possible values are:

MEDCON

Spooled file detail is removed when media content information is removed.

1 - 9999

Specify the number of days that spooled file detail is kept in the media content inventory.

 

retain-folder-detail (Optional)

Specifies the number of days to keep folder level detail when the STRMNTBRM command processes.

Possible values are:

MEDCON

Folder detail is removed when media content information is removed.

1 - 9999

Specify the number of days that folder detail is kept in the media content inventory.

 

remove-migration-info (Optional)

Specifies how old in number of days that migration information should be before it is removed when the STRMNTBRM command processes.

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 (Optional)

Specifies whether to process scheduled media movement when the STRMNTBRM command processes.

Possible values are:

NO

Scheduled media movements are not processed.

YES

Scheduled media movements are processed.

 

log-entries-days (Optional)

Specifies how old in number of days that log entries should be before they are removed when the STRMNTBRM command processes.

Possible values are:

1 - 99999

Specify the number of days after which log entries are removed.

 

run-cleanup (Optional)

Specifies whether clean up operations should be run when the STRMNTBRM command processes.

Possible values are:

NO

Clean up will not be performed.

YES

Clean up will be performed.

 

retrieve-volume-stats (Optional)

Specifies whether BRMS is to retrieve volume statistics when the STRMNTBRM command processes.

Possible values are:

NO

Volume statistics are not retrieved.

YES

Volume statistics are retrieved.

 

media-audit (Optional)

Specifies whether shared media attributes should be audited when the STRMNTBRM command processes.

Possible values are:

NO

Shared media attributes will not be audited.

YES

Shared media attributes will be audited.

 

change-journals (Optional)

Specifies whether to change the receivers for the BRMS journals when the STRMNTBRM command processes.

Possible values are:

NO

The journal receivers are not changed.

YES

The journal receivers are changed.

 

expired-media-report (Optional)

Specifies whether to print a report of media that is expired when the STRMNTBRM command processes.

Possible values are:

NO

Expired media report is not run.

YES

Expired media report is run.

 

version-report (Optional)

Specifies whether to print a version control report when the STRMNTBRM command processes.

Possible values are:

NO

A version control report is not run.

YES

A version control report is run.

 

media-info-report (Optional)

Specifies whether to print a report of what was backed up when the STRMNTBRM command processes.

Possible values are:

NO

A report of what was backed up is not run.

YES

A report of what was backed up today and yesterday is run.

 

recovery-activities-report (Optional)

Specifies whether to print the Recovery Activities report when the STRMNTBRM command processes.

Possible values are:

NO

The Recovery Activities report is not run.

YES

The Recovery Activities report is run.

 

system-recovery-report (Optional)

Specifies whether to print the Recovery Analysis report when the STRMNTBRM command processes.

Possible values are:

NO

The Recovery Analysis report is not run.

YES

The Recovery Analysis report is run.

 

save-exceptions-report (Optional)

Specifies whether to print the Save Strategy Exceptions report when the STRMNTBRM command processes.

Possible values are:

NO

The Save Strategy Exceptions report is not run.

YES

The Save Strategy Exceptions report is run.

 

system-info-report (Optional)

Specifies if BRMS should issue the PRTSYSINF command to produce reports of system information when the STRMNTBRM command processes.

Possible values are:

NO

System information reports are not run.

YES

System information reports are run.

 

Authorization: The privileges held by the authorization ID of the statement must include the following:

  • EXECUTE SQL privilege on this procedure

The BRMS Network feature is required.

The schema is QUSRBRM.

Examples:

To expire media:

call QUSRBRM.CHANGE_MAINTENANCE_POLICY(EXPIRE_MEDIA=> 'YES')

To not run clean up:

call QUSRBRM.CHANGE_MAINTENANCE_POLICY(RUN_CLEANUP=> 'NO')

To delete log entries over 90 days old:

call QUSRBRM.CHANGE_MAINTENANCE_POLICY(LOG_ENTRIES_DAYS=> 90)

Error Messages

The following SQL States and error messages may be returned by this procedure.

U0001

Unable to retrieve Maintenance Policy record.

U0002

Unable to update Maintenance Policy record.

U0003

Expire Media not valid. Must be NO or YES.

U0004

Expire Partial Set not valid. Must be NO or YES.

U0005

Remove Media Info not valid. Must be EXPIRED, NONE or REUSED.

U0006

Retain Object Detail not valid. Must be MEDCON or 1-9999.

U0007

Retain Link Detail not valid. Must be MEDCON or 1-9999.

U0008

Retain Splf Detail not valid. Must be MEDCON or 1-9999.

U0009

Retain Folder Detail not valid. Must be MEDCON or 1-9999.

U0010

Remove Migration Info not valid. Must be NONE or 1-9999.

U0011

Run Move Policies not valid. Must be NO or YES.

U0012

Log Entries Days not valid. Must be 0-99999.

U0013

Run Cleanup not valid. Must be NO or YES.

U0014

Retrieve Volume Stats not valid. Must be NO or YES.

U0015

Media Audit not valid. Must be NO or YES.

U0016

Change Journals not valid. Must be NO or YES.

U0017

Expired Media Report not valid. Must be NO or YES.

U0018

Version Report not valid. Must be NO or YES.

U0019

Media Info Report not valid. Must be NO or YES.

U0020

Recovery Activities Report not valid. Must be NO or YES.

U0021

System Recovery Report not valid. Must be NO or YES.

U0022

Save Exceptions Report not valid. Must be NO or YES.

U0023

System Info Report not valid. Must be NO or YES.

U9999

Illegal execution.

Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.