OS User Id information

rmarzullo · #1 (**permalink**) 12-04-08, 13:21

I am running DB2 ESE v9.1.4 on Windows 64 bits server.
I would like ot know if there is any way (if any simple) to obtain OS User Id information which is connecting / accessing information against DB2 database. I can see this information for example on tools cush as DB2 Monitor (freeware tool). So I know it is possible somehow.

Customer requested to have this information at application level so that they can store who is doing what (without audit tables).

Could anyone help me please?

Thanks

n_i · #2 (**permalink**) 12-04-08, 13:46

Snapshot functions?

select * from table (snapshot_appl_info('YOURDB', -1)) t

rmarzullo · #3 (**permalink**) 12-04-08, 14:29

Thanks Nick!
It worked like a Champ! That's exactly what I was looking for.

One question though, I don't need to run any "get snapshot for application" before issuing this SQL in order to refresh those snapshot tables right?
I mean if I connect to a database and I want to know who is accessing (is terms of user id) I don't need to "refresh this table?

Regards

n_i · #4 (**permalink**) 12-04-08, 14:35

No, you don't need to refresh anything, it retrieves the monitor data dynamically.

JAYANTA_DATTA · #5 (**permalink**) 12-05-08, 05:36

If you just want to know the users connected, you can also try the following on shell prompt:

db2 "list applications show detail" | awk '{print $1}'

n_i · #6 (**permalink**) 12-05-08, 08:18

Quote:

Originally Posted by JAYANTA_DATTA

db2 "list applications show detail" | awk '{print $1}'

Just curious, why do you use "show detail" if you are only extracting the first column anyway?

Marcus_A · #7 (**permalink**) 12-05-08, 17:12

Separately, I noticed in 9.5 (not sure about 9.1) they finally got rid of the hex values of the client IP address on the list applications command and display it in normal decimal format.