Kbase P75049: How to redirect the temporary files created by SQL-92 server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2009 |
|
Status: Verified
GOAL:
How to redirect the temporary files created by SQL-92 server?
GOAL:
What is a file "M<random number>" created by SQL-92 server?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
A SQL-92 server allocates files named "M<random number>" as temporary files. They are hidden files so you will not see them.
To modify the location that this temporary files will be created on UNIX systems, you can use the environment variable WRKDIR. By changing the WRKDIR, you will be changing not only the temporary files but everything that uses the WRKDIR. On Windows platform reset the windows registry key "WorkPath" located at HKEY_LOCAL_MACHINE\SOFTWARE\PSC\PROGRESS\<VERSION> to redirect the location of those temp files.
Database needs to be restarted after the WRKDIR has changed.