The Question is:
Is there any way of determining which process-id
is locking a particular RMS record in a file ?
We run a system with 300+ on-line users. During the middle of the day (lunch
time) we have a serious of batch update programs which need to run but often
get stuck becuase 1 product record
is locked by 1 on-line user (who has propably gone to lunch). Whilst we have
utilities to view
each process individually to see what it is doing - it is virtually impossible
and very time consuming to go through upto 300 processes to try to find the
single process cuasing the lock. Is there any Software available which can
determine which PID are locking which records ?
The Answer is :
Please see topics 3169, 3320, 3498, 4741.