|
Question: How do I move the SQL Anywhere temporary file for Foxhound to a different physical drive?
Answer:
One method is to set the SATMP environment variable to specify the folder where SQL Anywhere will put all its temporary files:
Control Panel in Windows 7...
System
- Advanced system settings
- Advanced tab
- Environment Variables button
- System variables
- New... button
- New System Variable dialog box
Variable name: SATMP
Variable value: F:\data\SQL_Anywhere_temp
In a batch file...
SET SATMP=F:\data\SQL_Anywhere_temp
|
Another method is to modify the dbsrv16.exe command line which starts Foxhound to include the -dt F:\data\SQL_Anywhere_temp option;
this will only affect the temporary file associated with the Foxhound database:
"%SQLANY16%\%BIN%\dbspawn.exe"^
-f "%SQLANY16%\%BIN%\dbsrv16.exe"^
-c 25p^
-ch 50p^
-cr-^
-dt F:\data\SQL_Anywhere_temp^
-gk all^
-gn 220^
-gna 0^
-n foxhound4^
-o foxhound4_debug.txt^
-oe foxhound4_debug_startup.txt^
-on 1M^
-sb 0^
-ufd restart^
-x tcpip^
-xd^
-xs http(port=80;maxsize=0;to=600;kto=600)^
foxhound4.db^
-n f
|
Here's the list of Foxhound command files which contain the dbsrv16.exe command:
$backup_foxhound4.bat
$start_foxhound4_chrome.bat
$start_foxhound4_chrome_debug.bat
$start_foxhound4_default_browser.bat
$start_foxhound4_default_browser_debug.bat
$start_foxhound4_engine.bat
$start_foxhound4_firefox.bat
$start_foxhound4_firefox_debug.bat
$start_foxhound4_ie.bat
$start_foxhound4_ie_debug.bat
By default, those command files are installed here on Windows 7:
C:\ProgramData\RisingRoad\Foxhound4
|
|