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 ..
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.