|
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 10...
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 dbsrv17.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:
"%SQLANY17%\%BIN%\dbspawn.exe"^
-f "%SQLANY17%\%BIN%\dbsrv17.exe"^
-c 25p^
-ch 50p^
-cr-^
-dt F:\data\SQL_Anywhere_temp^
-gk all^
-gn 220^
-gna 0^
-m^
-n foxhound5^
-o foxhound5_debug.txt^
-oe foxhound5_debug_startup.txt^
-on 1M^
-sb 0^
-ufd restart^
-x tcpip^
-xd^
-xs http(port=80;maxsize=0;to=600;kto=600)^
foxhound5.db^
-n f
|
Here's the list of Foxhound command files which contain the dbsrv17.exe command:
C:\ProgramData\RisingRoad\Foxhound5\
$backup_foxhound5.bat
$start_foxhound5_default_browser_debug.bat
$start_foxhound5_default_browser.bat
$start_foxhound5_engine.bat
C:\ProgramData\RisingRoad\Foxhound5\scripts
$create_SQL_Anywhere_17_bin64_service.bat
$MULTI_Step_2_dbsrv_all.bat
$MULTI_Step_2b_dbsrv_one.bat
$run_most_recent_mini_restore.bat
$TEN_INSTANCES_2_dbsrv.bat
|
|