|
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 dbsrv12.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:
"%SQLANY12%\Bin64\dbspawn.exe"^
-f^
"%SQLANY12%\Bin64\dbsrv12.exe"^
-c 25p^
-ch 50p^
-cr-^
-dt F:\data\SQL_Anywhere_temp^
-gk all^
-gn 120^
-gna 0^
-n foxhound1^
-o foxhound1_debug.txt^
-oe foxhound1_debug_startup.txt^
-on 1M^
-qn^
-sb 0^
-x tcpip^
-xd^
-xs https(identity="%SQLANY12%\Bin64\rsaserver.id";identity_password=test;port=443;maxsize=0;to=600;kto=600)^
foxhound1.db^
-n f
Here's the list of Foxhound command files which contain the dbsrv12.exe command:
$backup_foxhound1.bat
$start_foxhound1_chrome.bat
$start_foxhound1_chrome_debug.bat
$start_foxhound1_engine.bat
$start_foxhound1_firefox.bat
$start_foxhound1_firefox_debug.bat
$start_foxhound1_ie.bat
$start_foxhound1_ie_debug.bat
By default, the Foxhound command files are installed in this location on Windows XP:
C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound1
and on Vista and Windows 7 it is here:
C:\ProgramData\RisingRoad\Foxhound1
|