Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    8

    Question Unanswered: please help me with this

    Hi, I work with DB2 UDB 6.0 and a NT Server
    I need to know if exists some command to consult which table (or rows) is locked, via commands center or to commands process line. Please it's urgent.

    Thank you

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

    Re: please help me with this

    db2 get snapshot
    command

    This command can be used to get the snapshot at application level, db level, for locks , for bufferpool, for tablespaces, tables etc.

    To know if an application is waiting on locks, from the command line

    db2 get snapshot for applications on <dbname>

    Have a look at Command Reference for details ..

    HTH

    Cheers

    Sathyaram



    Originally posted by cytrus
    Hi, I work with DB2 UDB 6.0 and a NT Server
    I need to know if exists some command to consult which table (or rows) is locked, via commands center or to commands process line. Please it's urgent.

    Thank you

Posting Permissions

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