Cleaning up BRMS Data Files

Chris Flick, Technician at iTech SolutionsBRMS is not a set it and forget it backup and recovery application.  Since BRMS uses database files to store information, some of these files can get large and have many records inserted and/or deleted every day.  There are ways that you can clean up BRMS data files on a regular and as-needed basis.

Regular BRMS data files cleanup strategy:

BRMS recommends that the Start Maintenance for BRM (STRMNTBRM) command with *YES specified for the reorganize BRMS database (RGZBRMDB) parameter, is run at least once a month to clean up the files.  Because it can take a long time to reorganize the BRMS database, it may be desirable to reorganize the BRMS database in batch using the STRMNTBRM command, and performing this when no other BRMS activity is being performed.  The more often you run it, the less time it takes to run.  I would recommend running daily, as part of your BRMS strategy to include:

  • RMVMEDIBRM – Remove media information from BRM
  • MOVMEDBRM – Move media using BRM
  • STREXPBRM – Expire media from BRM
  • RMVLOGEBRM – Remove BRM log entries
  • WRKMEDIBRM – Work with media information
  • STRRCYBRM – Recovery analysis

Note: STRMNTBRM command should not be used by control group *EXIT item processing as results will be unpredictable, and all object authority is required to run this command.

As needed BRMS data files cleanup strategy:

On particular file that you may notice, is a BRMS file called QA1ALI2, in library QUSRBRM, may be very large, and is a file that its size can be reduced.  And here’s how:

The QUSRBRM/QA1ALI2 physical file saves object level detail for the Integrated File System (IFS). The following actions are recommended to reduce this physical file:

  • Do not specify Object Level Detail *YES on control groups that saves the IFS data. If *NO is specified, you will not be able to use BRMS to ‘drill’ down to individual files in directories to restore via BRMS, but you can use the native Restore Object (RST) command to restore the information. You can also use WRKMEDIBRM for an Integrated File System item (*LINK) command with Option 7 (Restore), then another Option 7 (Specify object) and then specify the file.
    Note: If using the SAVDOMBRM command (Domino On-Line backups), the object level detail is automatically saved.
  • Review media retention times. If it is reasonable to reduce the retention time and when the STRMNTBRM RMVMEDI(*EXP) is used, the media information (including object level detail) will be deleted and thus reduce the size of QA1ALI2.
  • If this file consists of many deleted records, a Reorganize Physical File Member (RGZPFM) command can be used to get rid of deleted records and get some disk space. When the RGZPFM command is run, BRMS should not be in use on that system. If this system is part of a BRMS network, BRMS activity on the other systems in the network does not affect this.
  • If disk space is needed immediately, the following steps can be used:
    1. Run the SAVOBJ OBJ(QA1ALI2) LIB(QUSRBRM) command to save it to tape or save file.
    2. Run the CLRPFM FILE(QUSRBRM/QA1ALI2) command.
    3. Once DASD has been increased, restore the file saved in step 1.into a different library, and then use the command: CPYF FROMFILE(new lib/QA1ALI2) TOFILE(QUSRBRM/QA1ALI2) MBROPT(*ADD). This will merge the data from the old QA1ALI2 file with the current data in the QA1ALI2 file in QUSRBRM.
Tagged with: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*