Removing corrupted data and compacting the Report Builder database

As an administrator, you can use the rs_compact command to remove corrupted data and to compact the Report Builder database.

About this task

Run this command from the Jazz_Install_Dir/server directory.
rs_compact command parameters:
  • -applicationcontextroot <value>, where <value> is the current Jazz Reporting Service root, for example /rs.
  • -dblocation <value>, where <value> is the full path to the JRS database file. By default, it is Jazz_Install_Dir/server/conf/rs/db.
Note: For z/OS, the SBLZSAMP data set member BLZRSCMP contains sample JCL that can be used to run the rs_compact utility. Customize the BLZRSCMP job based on the instructions in the comments included in the sample JCL, submit the job, and verify the output.

Procedure

  1. Shut down the server.
  2. Open the command prompt, and go to the Jazz_Install_Dir/server directory.
  3. Type one of the following commands, and press Enter:
    • If you are using the default Jazz Reporting Service context root and database location:
      • Windows upgrade\rs\rs_compact.bat
      • Linux upgrade/rs/rs_compact.sh
    • If your Jazz Reporting Service context root is /rb:
      • Windows upgrade\rb\rs_compact.bat
      • Linux upgrade/rb/rs_compact.sh
    • If you are not using the default database location:
      • Windows upgrade\rs\rs_compact.bat -dbLocation \Jazz_Install_Dir\Report_Builder_DB
      • Linux upgrade/rs/rs_compact.sh -dbLocation /Jazz_Install_Dir/Report_Builder_DB
    • If you are not using the default Jazz Reporting Service context root and database location:
      • Windows upgrade\rb\rs_compact.bat -applicationContextRoot rb -dbLocation :\Jazz_Install_Dir\server\Report_Builder_DB
      • Linux upgrade/rb/rs_compact.sh -applicationContextRoot rb -dbLocation :/Jazz_Install_Dir/server/Report_Builder_DB