The second command should be: db2 get snapshot for locks on <dbname>
or if you want detailed information about one connection: db2 get snapshot for locks for application agentid <id> or db2 get snapshot for locks for application applid <applid> Kind regards, Gert ----- Original Message ----- From: "Pierre Saint-Jacques" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 03, 2001 8:41 PM Subject: Re: DB2EUG: Best way to monitor locks? > Look at the snapshot command and options. > > db2 update monitor switches for locks on > db2 get snapshot on database <dbname> > > I'm doing the commands from memory so they may have to be revised. > HTH, Pierre. > > "Henry J. Cobb" wrote: > > > What's the best way to print out the current locks in the database? > > > > Say, the application, the table, the type of lock and which client? > > > > -HJC > > > > ===== > > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > > For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
