Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Storage Manager (STM) > SRM Profiler Administrator Guide > SRM Profiler database > Database Maintenance using Dbutil

Database Maintenance using Dbutil

Updated: June 16, 2017

Dbutil is a script that ships with SRM Profiler and allows you to make backups of your database and run maintenance routines to keep the database running smoothly.

All SRM Profiler Services are halted when this utility runs.

Depending on which platform you are running, directions are below explaining how to run dbutil in your environment.

Run dbutil in Windows

The dbutil.bat file is located in the <installed drive>:\Program Files\SolarWinds\Storage Manager Server\bin directory.

Preparation

  1. Using a text editor, edit your dbutil.bat file and find the following string: Set BackupStage=C:emp\mariadb_backup
  2. Change the path C:emp\mariadb_backup to the directory where you would like to backup your profiler database.

: It is recommended that you do not use a directory within the SRM Profiler install directory and you need to verify that the location selected has sufficient free disk space for your database.

Usage

dbutil.bat [backup|maintenance]

Options

  • backup: Copy database to backup directory
  • maintenance: Run database repair/analysis/optimization procedures
  • default (no options specified): Executes maintenance and backup

Scheduling

To run this using Windows task scheduler.

  1. Open Windows Task Scheduler and Create a Basic Task with your desired schedule (Weekly for example).
  2. Set the Action as Start a Program.
  3. Program/script = \bin\dbutil.bat
  4. Set the arguments to "backup" to only do a backup if desired.

Run dbutil in Linux

The dbutil.bat file is located in the <installed drive>/Storage_Manager_Server/bin directory.

Preparation

  1. Edit your dbutil.sh file and find the following string: export backupStage=/opt/mariadb_backup
  2. Change the path /opt/mariadb_backup to the directory where you would like to backup your profiler database.

: It is recommended that you do not use a directory within the SRM Profiler install directory and you need to verify that the location selected has sufficient free disk space for your database.

Usage

dbutil.sh [backup|maintenance]

Options

  • backup: Copy database to backup directory
  • maintenance: Run database repair/analysis/optimization procedures
  • default (no options specified): Executes maintenance and backup

Scheduling

Create a cron job to run the dbutil.sh on a schedule.

 
Last modified
11:16, 26 Jun 2017

Tags

Classifications

Public