User's logged on to DB2

db2man · #1 (**permalink**) 11-03-04, 05:50

HEY ALL,

How can we check what users are logged on to DB2 and what jobs they are executing. How do you list the users in DB2.

J Petruk · #2 (**permalink**) 11-03-04, 08:20

Quote:

Originally Posted by db2man

HEY ALL,

How can we check what users are logged on to DB2 and what jobs they are executing. How do you list the users in DB2.

db2 list applications [show detail]
or
db2 get snapshot for all on <dbname>
if you need more detail

maxzsim · #3 (**permalink**) 08-13-09, 01:43

Hi ,

is there's any views that i select from instead and btw how do i execute the
db2 list applications ?

pls advise

Marcus_A · #4 (**permalink**) 08-13-09, 03:17

Yes, if you have a "newer" version of DB2, there are administrative views that contain basically the same info as the snapshots. Do a search on "administrative views" in the DB2 InfoCenter website.

Internet Services

Web Development

Digital Marketing

Consumer Tech