Move Fathom Trend DB online? - Forum - OpenEdge RDBMS - Progress Community

Move Fathom Trend DB online?

 Forum

Move Fathom Trend DB online?

This question is not answered

Has anyone any experience of moving the Fathom Trend Database? Our customer's database has grown to nearly fill the available space and they want us to move it to a volume with more available space. 

My thoughts are that I can use the following process to do it online, but if anyone has a better method, or sees any problems please let me know. 

  • Shut down the adminservice
  • Shut down the Fathom DB
  • Move the DB to the new location
  • Edit .st file
  • Prostrct Repair
  • Restart DB
  • Restart adminservice

Thoughts?

OE 10.2B08 on Windows. 

All Replies
  • it's no different than any other DB move so your procedure sounds good to me. Are you running the purge/compact job? If not that will help keep the DB size in check.

    You can probably get away with only stopping fathom and not the whole AdminService if stopping the AdminService is a problem.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com
  • I'd forgotten about the compaction routine. I'll give that a whirl.

  • I would recommend running a table analysis before attempting to run the compaction online.  We found a large amount of data in some tables that we didn't report on - the app servers for example.  We manually purged a lot of data before attempting to run an online compaction.

  • Before restarting the adminservice, Update the new Fathom DB path in $DLC\properties\conmgr.properties file.
     
    Thanks,
    Satya