Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    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)
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: tracking select statements to IP address

    You can use Event Monitor ...

    Create a STATEMENT Monitor with the clause WHERE AUTH_ID='Connid' ...

    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)
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •