Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Locked users table.

    Could anyone tell me which table gives (or how to find out) the statistics of active-connection by a user; any tables being locked by user?

    Oracle equivalent : v$locked_object, v$session etc..

    Thanks for your help.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Best way I have found is to use this freeware monitor:

    http://chuzhoi_files.tripod.com/index.html

    Andy

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: Locked users table.

    db2 list applications show detail

    for connected users

    db2 get snapshot for locks or tabes on database db-name

    for locks and tables.

    HTH

    dollar

    Originally posted by techno
    Could anyone tell me which table gives (or how to find out) the statistics of active-connection by a user; any tables being locked by user?

    Oracle equivalent : v$locked_object, v$session etc..

    Thanks for your help.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Locked users table.

    If you have V8 , then you can use the following table functions

    SNAPSHOT_LOCK
    SNAPSHOT_TABLE

    Refer the db2 manuals or 'google' for these terms

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Holy cows,

    That is some nice piece of freeware, Andy

    Thanks for pointing to it...............
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

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