Who is using my table.

georgipa · #1 (**permalink**) 05-05-11, 15:03

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.

rajaraja_cholan · #2 (**permalink**) 05-05-11, 15:39

use event monitor?

n_i · #3 (**permalink**) 05-05-11, 15:47

Quote:

Originally Posted by georgipa

how to know what user is using my table.

What do you mean by "using my table"?

georgipa · #4 (**permalink**) 05-05-11, 15:54

what applications or session have to open my table.

Thank you

georgipa · #5 (**permalink**) 05-05-11, 15:56

There are any select where show me who have to open my table?
Thank you.

n_i · #6 (**permalink**) 05-05-11, 18:41

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech