Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    28

    Unanswered: User's logged on to DB2

    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.

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    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
    Last edited by J Petruk; 11-03-04 at 09:29.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    May 2009
    Posts
    4

    user logged on to DB2

    Hi ,

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

    pls advise

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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