Kbase P160777: How to set where the SQLEXP command-line tool creates its log files
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/02/2010 |
|
Status: Unverified
GOAL:
How to set where the SQLEXP command-line tool creates its log files
GOAL:
How to configure where the SQLEXP command-line tool creates its log files
GOAL:
How to configure where the SQLEXP command-line tool creates the sqlexp.log and SQLExplorer.properties files
FACT(s) (Environment):
OpenEdge Category: SQL
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
FIX:
It is possible to control where sqlexp log files are created but only by modifying the <DLC>\bin\sqlexp.bat on Windows or <DLC>/bin/sqlexp script on UNIX. There are no startup parameters that allows a value to be specified.
Take a copy of the sqlexp script in <DLC>\bin as a backup.
To set the directory, add the following parameter to the exec statement at the end of the sqlexp script:
-Duser.dir=<path>
For example:
-Duser.dir=/users/sqltmp
UNIX:
exec $JVMSTRT -o stderr -m silent -a $TOOLSPROP::$TOOLSGRP $JREHOME/bin/$JVMEXE -DInstall.Dir=${DLC} -Duser.dir=/users/sqltmp -cp ${CLASSPATH} ${SQLEXPCLASS} "$@"
Windows:
%JVMSTRT% -a "%TOOLSPROP%"::%TOOLSGRP% -o stderr -s -m silent "%JVM%" -DInstall.Dir="%DLC%" -Duser.dir=C:\temp %PROSQLJVMARGS% %SQLEXPCLASS% %*