Re: Detailed Status of Locks ?

Jens Ebert <ebert@mail.ppp.net> wrote in article <01bcafcc$7a872e40$d10c40c2@ebert.ppp.net>... > <snip> > does someone has or knows abour a nice tool to show all the > locks set on certain objects in a Onlien database? > > I would like to see who owns the locks and what kind of locks > they are. > <snip> You can do this with a query against the syslocks table in the sysmaster database. (Versions 7.x & later -- maybe in 6.x as well). There is a script called 'onlocks' at http://www.objectsoft.com that does this. Feel free to download & use it as is or as an example of how to build your own tool. -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com