Forum Discussion

Ivy_Yang's avatar
Ivy_Yang
Level 6
13 years ago

how to defrag Opscenter?

hi,

we have a Opscenter7.1.0.1 running on Windows 2008 standard R2 with 2 processors/8G.

it's a VM and houses the OpsCenter only.

Recently we received CPU high unilization alerts from this server........and we narrow down the issue to the NetBackup OpsCenter services, when stopped the CPU load goes down to a low level. ......

and besides I found the following warning in "D:\Program Files\Symantec\OpsCenter\server\db\log\server.log"

04/17 14:32:06. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\vxpmdb.db" consists of 1248 disk fragments
04/17 14:32:07. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\symcOpscache.db" consists of 292 disk fragments....

it seems we need to defrag the Opscenter databases so as to increase data access and retrieval speed...I am not sure..but I wanted to try it since our OpsCenter has been running for about 10 months and manages 7 masters...the database must be very large....

 

my question is that :

1)how to defrag the database ? is that mean we need to purge some obsolete data?

2)I ran the "dbdefrag" today but I didn't see any change via the server.log ..so I ran it 3 times.......and after I ran this command what else do I need to do ?

after defragmentation, how long is the data kept in Opscenter databases?

D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database...
Terminate batch job (Y/N)? Y

D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database...
Error in Export of vxpmdb
Starting the OpsCenter Database...
Starting the OpsCenter Server...
Starting OpsCenter Web Console Service...

D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database......

 

sorry about so many questions...I am lost with this defragmentation

7.1.x and Earlier
Backup and Recovery
Error messages
Monitoring
OpsCenter
  • Mark_Solutions's avatar
    Mark_Solutions
    13 years ago

    It does the data purge each day at the time shown in the bottom box on the data purge screen - i believe this defaults to 00:00 (midnight) so once that time has passed the data will be nicely purged and you can run your defag.

6 Replies

Sort By
  • Mark_Solutions's avatar
    Mark_Solutions
    Level 6
    13 years ago

    All of your commands look fine - the amount of data kept in OpsCenter is controlled in the Settings - Configuration - Data Purge

    If you want to change any of these then do so, wait until after the "time of purge" and then defrag the database to tidy things up.

    Also be careful when you finally upgrade as there is an issue in 7.1.0.3 where is starts to use only one processor - this is what i thought may be your issue but you say you are on 7.1.0.1 (maybe worth a check anyway - http://www.symantec.com/docs/TECH178219)

    On a standard install the reports work for 60 days, on analytics for as log as you like - however the data is kept pretty much forever depending on what you pruning settings are

    Hope this helps

  • Ivy_Yang's avatar
    Ivy_Yang
    Level 6
    13 years ago

    hi, Mark thanks for your reply

    our opscenter version is indeed 7.1.0.1 (Build 20110612)..

    So let me make it clear:

     I need to do the "Data Purge" via OpsCenter GUI first and then run the "dbdefrag" to tidfy things up..................right?smiley

  • Ivy_Yang's avatar
    Ivy_Yang
    Level 6
    13 years ago

    and by the way, it prompted that "Data Purge Configuration updated successfully"...

    but when will the OpsCenter do the Data Purge? does it have a default schedule for this?

  • Mark_Solutions's avatar
    Mark_Solutions
    Level 6
    13 years ago

    It does the data purge each day at the time shown in the bottom box on the data purge screen - i believe this defaults to 00:00 (midnight) so once that time has passed the data will be nicely purged and you can run your defag.

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    13 years ago

    Data Purge will process (by default) at 12:00am each day.

    However, it will also kick off when you restart OpsCenter Database, if the purge is due to run.

    You can check the purge-status.log to determine when and how much information is removed from the database.

    ./installpath/OpsCenter/Server/log/purge-status.log