How to find out where the OpenEdge SQL server side logs should be created for an OpenEdge database running on a Linux machine ?

Sometimes OpenEdge SQL server side logs are not being created because of Linux permissions issues on unexpected sql log file locations.

The location for the creation of the sql log files is determined by the folder location used when executing the command to start the OpenEdge database. 

The pid of the current _sqlsrv2 process first need to be known, this can be done using the following sql statement:

SELECT "_MyConn-Pid" AS '_sqlsrv2 pid' FROM PUB."_MyConnection";

this should return something like:

_sqlsrv2 pid
------------
24735

To find out all the pids of all the _sqlsrv2 running processes of all the OpenEdge databases the following Linux command can also be used: 

lsof | grep _sqlsrv2 | cut -d " " -f 1-4 | sort | uniq

this Linux command will return a list of all the running _sqlsrv2 process pids like this:

_sqlsrv2 17629
_sqlsrv2 24735
_sqlsrv2 22816
_sqlsrv2 22819

On one of those _sqlsrv2 pids as root execute an ls -al command like:

ls -al /proc/24735/ | grep -e cwd -e exe

(replace 24735 by the pid of one of the _sqlsrv2 process) this should then return something like:

lrwxrwxrwx 1 root root 0 Dec 18 08:07 cwd -> /usr/wrk/someFolder
lrwxrwxrwx 1 root root 0 Dec 18 08:07 exe -> /usr/dlc/bin/_sqlsrv2

or execute a Linux pwdx command like:

pwdx 24735

(replace 24735 by the pid of one of the _sqlsrv2 process) this should then return something like:

3589: /usr/wrk/someFolder

To verify Linux permissions, the Linux user that start the OpenEdge database and therefore the _sqlsrv2 process need to be able to create a test file in that folder using a command like:

touch /usr/wrk/someFolder/testFile.txt

When sql server side logging is enabled and a sql server side log is created and in use then the Linux command:

lsof | grep SQL_server

should then return something like:

_sqlsrv2   3589                root   44w      REG              253,0      2188   35001791 /usr/wrk/someFolder/SQL_server_1_20241218_083409_A.log

References to Other Documentation:

OpenEdge Data Management: SQL Reference, OpenEdge SQL Statements: "SET PRO_SERVER LOG"

https://docs.progress.com/bundle/openedge-sql-reference/page/SET-PRO_SERVER-LOG.html

Progress Article:

SQL-92: How to turn SQL statement logging on and off?

How to run a SQL-92 query to gather performance information against a SQL statement  

Is it possible to specify where the SQL statement logging log file will be created?