Administer > Database administration > Data persistence > Running the database maintenance utility

Running the database maintenance utility

There are several ways to run the database maintenance utility. Pick the one that best suits your needs.

Run the database maintenance utility in foreground (interactively) on Unix

Applies to User roles: System Administrator

By default, the Service Manager database utility executable is located in the \ Service Manager\Server\RUN directory.

To run the database maintenance utility interactively on Unix:

  1. Open a Unix Command prompt.
  2. Navigate to the Service Manager\Server\RUN directory.
  3. To have all input and output captured in a file, issue the following Unix command:
    script scriptname.out
  4. Issue the following command to start the Service Manager database utility:
    sm -util
  5. The script ends when the forked shell exits. (Use control-D to exit the Bourne shell (sh(1)), and exit, logout or control-d (if ignoreeof is not set) for the C-shell, csh(1)).
  6. Check the output. If you receive error messages, contact Micro Focus Support for assistance.

Run the database maintenance utility in background (batch) on Unix

Applies to User Roles:

System Administrator

To start the Service Manager database utility in the background, you must first create an input file that contains the commands that are normally entered using the keyboard.

To run the database maintenance utility in the background (batch) on Unix:

  1. Shut down the Service Manager server. (This will terminate the clients as well.)
  2. Open a Unix Command prompt.
  3. Navigate to the \ Service Manager\Server\RUN directory and type the following command: sm -util <filename.in >filename.out
    Where the filename.in variable is the name of the prepared input file and the filename.out variable is the name of the file containing the output.
  4. Check the output. If you receive error messages, contact Customer Support for assistance.

Run the database maintenance utility in foreground (interactively) on Windows

Applies to User roles: System Administrator

By default, the Service Manager database utility executable is located in the \ Service Manager\Server\RUN directory.

To run the database maintenance utility interactively on Windows:

  1. Open a Windows Command prompt or the Window RUN dialog box.
  2. Go to the Service Manager\Server\RUN directory and issue the following command: sm -util
    For example:
    C:\Program Files\MF\ Service Manager\Server\RUN> sm -util
    Your screen displays the Service Manager database utility main menu.
  3. Select an option to proceed.
  4. Check the output. If you receive error messages, contact Customer Support for assistance.

Run the database maintenance utility in the background (batch) on Windows

Applies to User Roles:

System Administrator

To start the database maintenance utility in the background, you must first create an input file that contains the commands that are normally entered using the keyboard.

By default, the database maintenance utility executable is located in the \ Service Manager\Server\RUN directory.

To run the database maintenance utility in background (batch) on Windows:

  1. Prepare the input file for the utilities you want to run.
  2. Shut down the Service Manager server. This will also terminate any active client sessions.
  3. Open a DOS Command prompt or the Windows Run dialog box.
  4. Navigate to the \ Service Manager\Server\RUN directory and type the following command:sm -util <filename.in >filename.out
    Where the filename.in variable is the name of the input file prepared and the filename.out variable is the name of the file containing the output.
  5. Check the output. If you receive error messages, contact Customer Support for assistance.