Kbase P46104: How to get dbman to start database with PROSQLTRC turned on?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/10/2003 |
|
Status: Unverified
GOAL:
How to get dbman to start database with PROSQLTRC turned on?
GOAL:
If I use dbman, how do I enable PROSQLTRC parameter for SQL-92?
FACT(s) (Environment):
Progress 9.1D
FIX:
PROSQLTRC is an environment variable that when passed to SQL-92 engine, will start writing tracing information to pid.trc files. SQL-92 gets this environment setting from os_getenv call, which only looks at the usr environment passed into the database start command.
If dbman is used, all the environment is passed from admin server, the user that starts admin server needs to have PROSQLTRC set in order to enable tracing.
On UNIX, set the environment variable for the usr that starts admin server.
On windows, set the system environment variable PROSQLTRC.
Note: If you have multiple databases administered by admin server, setting PROSQLTRC in admin server's user environment will start tracing for all the databases administered by admin server.