Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Who is using my table.

    Hi Colleagues,

    I am using DB2 9.5 on AIX 5.3, somebody can say me how to know what user is using my table.

    Thank you for advanced.

  2. #2
    Join Date
    Dec 2008
    Posts
    44
    use event monitor?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by georgipa View Post
    how to know what user is using my table.
    What do you mean by "using my table"?

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    what applications or session have to open my table.

    Thank you

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    There are any select where show me who have to open my table?
    Thank you.

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I don't know what "open a table" means. You can see dynamic statements that reference the table in the package cache using db2pd, then find applications that execute them by the statement anchor ID (anchID). Alternatively, you could set up an activity event monitor and check statements as they are being executed.

    I'm not sure how to deal with static SQL though.

    I wonder what is the purpose of this.

Posting Permissions

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