Question Gathering Info on ODBC Connections

[Austin Skrepak]

Is there any way to track down information on any current active ODBC queries on the system? Windows username, server, etc.

Thanks!

 

[Rob Fitzpatrick]

What is your Progress version?

 

[Austin Skrepak]

10.2A

 

[Rob Fitzpatrick]

You can enable database client-request statement caching for selected existing SQL clients, or for all current clients, or all future clients. This is done in promon R&D 1, 18. There are other recent threads here that talk about this feature. It is available in 10.1C and later.

You can also look at SQL statement or query plan logging. Read this KB article:
SQL-92: How to turn SQL statement logging on and off?
http://knowledgebase.progress.com/articles/Article/P119161/p

 

[Austin Skrepak]

Thank you!

 

[Austin Skrepak]

Is there a way to trace back a _sqlsvr2 PID to the specific SQL log file?

 

[Rob Fitzpatrick]

SQL logging files are named with the date and time stamp but they don't contain PID info like a DB log. However they do contain the server ID. You can use this to identify the server.

Example:

# cat SQL_server_1_20140204_170222_A.log
SQL LOG Section Started at 20140204_170222

SQL Environment Variable Settings:
  CLASSPATH=UNDEFINED

SQL LOG CONFIGURATION
  STATEMENT

SQL LOG FILE MAXIMUM SIZE: 500000000 Bytes

SQL SERVER ID: 1

20140204_170357 -627181824:
Freeing Cursor for SQL Statement: set pro_server log on with ( statement )
20140204_170357 -627181824:
Returning from sql_fn() with code: 0
20140204_170357 -627181824:
Setting Cursor for SQL Statement: select * from PUB.customer
...etc...