|
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 XP...
System
- Advanced tab
- Environment Variables button
- System variables
- New button
- New System Variable dialog box
Variable name: SATMP
Variable value: F:\data\SQL_Anywhere_temp
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 120^
-gna 0^
-n foxhound3^
-o foxhound3_debug.txt^
-oe foxhound3_debug_startup.txt^
-on 1M^
-sb 0^
-ufd restart^
-x tcpip^
-xd^
-xs http(port=80;maxsize=0;to=600;kto=600)^
foxhound3.db^
-n f
|
Here's the list of Foxhound command files which contain the dbsrv16.exe command:
$backup_foxhound3.bat
$start_foxhound3_chrome.bat
$start_foxhound3_chrome_debug.bat
$start_foxhound3_default_browser.bat
$start_foxhound3_default_browser_debug.bat
$start_foxhound3_engine.bat
$start_foxhound3_firefox.bat
$start_foxhound3_firefox_debug.bat
$start_foxhound3_ie.bat
$start_foxhound3_ie_debug.bat
By default, those command files are installed here on Windows XP:
C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound3
and on Windows 7 they are here:
C:\ProgramData\RisingRoad\Foxhound3
|
|