Archive Manager and DDM database

Document created by MichielHelder Champion on Jan 6, 2012Last modified by SamCreek on Dec 17, 2016
Version 5Show Document
  • View in full screen mode

Back to:

CA Spectrum

IM Community WIKI Front Page

 


How to disable the Archive Manager?


Just add the following line to your $SPECROOT/SS/.vnmrc

stat_logging_disabled=true

That easy

 

How to repair ArchiveManagers DDMDB?

While Archive Manager is running, use mysqlcheck:

cd $SPECROOT/mysql
bin/mysqlcheck -uroot -proot ddmdb

or

bin/mysqlcheck --auto-repair -uroot -proot ddmdb

If an error is found during the check, this will automatically fix it after all tables are checked.

 

If errors are found:

bin/mysqlcheck -r -uroot -proot ddmdb

 

If Archive Manager isn't runningyou can run myisamchk:

cd $SPECROOT/mysql
bin/myisamchk -m data/ddmdb/*.MYI

The medium check (-m) is supposed to catch 99.9% of errors.

 

If errors are found:

bin/myisamchk -r data/ddmdb/*.MYI

to recover/repair

 

To repair the db automatically in the future change your $SPECTRUM/SS/DDM/.configrc and add:

AUTO_REPAIR_DB=TRUE

 

 

How to change max table size of DDMDB?


The ArchiveManager has a default maximum table size of 2 GB. You may extend this limit by adding the following line to your $SPECROOT/SS/DDM/.configrc

TWO_GIGS=4294967295

If you change the maximum of days of data kept in the DDM you could prevent DDMDB getting this big. But under certain circumstances there is no alternative.

Attachments

    Outcomes