QUSRBRM.CHANGE_MAINTENANCE_POLICY Procedure
The QUSRBRM.CHANGE_MAINTENANCE_POLICY procedure allows you to change the maintenance policy.
Parameters
|
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.