how to find what table or tables are locked ??

[CedricLB]

Hi,

Sorry for my bad english

We have a problem on Progress 9.1D09 database, there are a lot of locks on table or tables but we dont know what table/tables are locked.

We have fathom for management but with this utilitie i dont see the db tables.

The Progress support tell me by mail:

--------------------------------
Problem Description:
How to monitor table locks with Fathom

--------------------------------------------------------------------------------
12/15/05 11:49 llaubach ACTION LOG ENTRY BY: XXXXXXXXX
Cedric,

you can monitor what records are currently locked, and then using the recid
you can thru VST query can the table name. That is possible. The first part
in Fathom, the 2nd part would require a bit of 4GL coding.

You can also use RAW VST data -> _UserLock, all database Database resource
+ User Activiy or RawVST data.

Unfortunetally, the data are real-time, they won't get stored in trend
database in such a level of detail. Database Locking report has only a
summary of how many locks were held and what was the type of the lock, but
it does not have it by user.

Kind regards
XXXXXXXXXX
Progress Support EMEA
------------------------------

I dont know coding in 4GL... :runtear:

One of you has an little program or script to find what tables are locked ???

Please help me :toast:

Thank you.

 

[TomBascom]

ProTop can tell you all sorts of interesting things about locks. Including who has what locks on what tables.

Be warned however that analyzing large sets of locks can be very slow.

http://www.greenfieldtech.com/articles/protop.shtml

 

[CedricLB]

tank's, i go to test this program.