Reorganizing BRMS data files

BRMS uses database files to store information.  Some of these files may get large and have many records inserted and/or deleted each day.  When saving object level detail, files are more susceptible to large numbers of deleted records as media expires.  BRMS recommends that the Start Maintenance for BRM (STRMNTBRM) command with *YES or *BATCH specified for the Reorganize BRMS database (RGZBRMDB) parameter is run as needed to clean up the files.  The Start Maintenance for BRM (STRMNTBRM) command will identify when a reorganization of a BRMS file is needed by posting a BRM402A message in the job log and BRMS log.

When performing a reorganization of BRMS files using STRMNTBRM, BRMS recommends the following best practice:

• All BRMS activity should be suspended during the reorganization process.
• When running the reorganization on a system in a BRMS network, to avoid file locks the BRMS network subsystems should be ended before running the STRMNTBRM command and restarted once the BRMS maintenance and reorganization is complete.
  • ENDSBS SBS(Q1ABRMNET) OPTION(*IMMED)
  • ENDSBS SBS(Q1ABRMENT) OPTION(*IMMED)
• All other STRMNTBRM command options should be turned off, the command should be:
  • STRMNTBRM EXPMED(*NO)

                    RMVMEDI(*NONE) 

                    RUNCLNUP(*NO)

                    RTVVOLSTAT(*NO)

                    CHGJRN(*NO)

                    PRTEXPMED(*NO)

                    PRTVSNRPT(*NO)

                    PRTBKUACT(*NO)

                    PRTRCYRPT(*NONE)

                    RGZBRMDB(*YES) should be only option turned on

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.