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 from Jazz_Install_Dir/server directory.
rs_compact command parameters:
  • -applicationcontextroot <value>, where <value> is the current Jazz Reporting Service (JRS) 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 the following commands, and press Enter:
    • If you are using the default JRS context root and database location:
      • Windows upgrade\rs\rs_compact.bat
      • Linux upgrade/rs/rs_compact.sh
    • If your JRS 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 JRS 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