If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: tracking select statements to IP address

Imagine having sales reps using Excel to download data from DB2 tables.
In order to keep things simple all sales reps connect to the database with the same id (which is set in the ODBC connection at their desk or laptop).
Wondering whether I can still determine which tables are used for select statements by which reps? db2diag.log does not log select statements as far as I know.
Using DB2 workgroup edition version 7.1.
Anyone a suggestion?

(sales reps connect from server to server, since they are all over europe)

Re: tracking select statements to IP address

db2eva output will contain the application id using which you can find the client used for connection

Cheers
Sathyaram

Originally posted by blom0344
Imagine having sales reps using Excel to download data from DB2 tables.
In order to keep things simple all sales reps connect to the database with the same id (which is set in the ODBC connection at their desk or laptop).
Wondering whether I can still determine which tables are used for select statements by which reps? db2diag.log does not log select statements as far as I know.
Using DB2 workgroup edition version 7.1.
Anyone a suggestion?

(sales reps connect from server to server, since they are all over europe)