Tech Tip - Can I move any or all of the datafiles used by the eHealth DB to a drive with more space?

Document created by Rich_V Employee on Jul 31, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

 

Q.

 

Can I move any or all of the datafiles used by the eHealth DB to a drive with more space?

 

A.

 

We provide a tool to add or move the datafiles.

 

NhManageDbSpace

 

Not all datafiles can be moved, however.

 

Only the following tablespaces can be moved using this option: NH_USERS, NH_INDEX, NH_DATA01, and NH_DATA02.

 

Before moving any of these tablespaces you must stop the CA eHealth server and database, check the memory and semaphores sections for active processes associated with the nhUser account, and stop those processes.

 

Here is example syntax:

 

 

 

NhManageDbSpace -evaluate -move -newPath <your path> -datafile NH_DATA01b

 

 

 

If it returns successful, remove the -evaluate and re-run to actually move the file.

 

Attachments

    Outcomes