1. Support
  2. Knowledge base
  3. 100039082

How to defrag the OpsCenter Database

Article: 100039082
Last Published: 2023-02-08
Ratings: 4 1
Product(s): NetBackup & Alta Data Protection

Description

The dbdefrag script is used to defragment the OpsCenter database.


NOTE: Always take an online backup of the OpsCenter Database before performing defragmentation using the dbbackup script (It backs up the database files, database password files, and encryption key file in the backup directory that you specified):

Windows: 
<install_path>\OpsCenter\server\bin\dbbackup.bat X:\MyDbBackupFolder
 
UNIX:
<install_path>/SYMCOpsCenterServer/bin/dbbackup.sh /my_db_backup_dir


To defragment the OpsCenter database run the following command (there are no arguments for the command):

Windows: 
<install_path>\OpsCenter\server\bin\dbdefrag.bat
 
UNIX:
<install_path>/SYMCOpsCenterServer/bin/dbdefrag.sh

Note:

  • dbdefrag should be run monthly.
  • dbdefrag should be run from a console session - not a remote session that might timeout
  • Ensure OpsCenter is not accessible while dbdefrag is running.
  • There needs to be at least two times the size of the database of disk space available.
For example, if the database is 10GB in size, then 20GB of available disk space is needed.

How can the size of the database be determined?
 
Add together the sizes of the four .db files ( vxpmdb.db, symcsearchdb.db, symcopssratchdb.db, syscOpscache.db) located in:
Windows: 
<install_path>\OpsCenter\Server\db\data
UNIX:  
<install_path>/INSTALL_PATH/SYMCOpsCenterServer/db/data

Was this content helpful?

Article Languages