A customer which runs an interface program to update records in our database is facing the problem that the interface is requesting a lock for a record which has a shraed lock on t. After half an hour the lock is cancelled based on the default lock wait time setting of 30 minutes.
In the lock table you see the record id of the record with the shared lock. Following a knowledge base article you can check in which table this record resides. But is there a way to also check which .p has locked the record..?
I have checked the Virtual System Table fields but see no clue on how to do this....
In the lock table you see the record id of the record with the shared lock. Following a knowledge base article you can check in which table this record resides. But is there a way to also check which .p has locked the record..?
I have checked the Virtual System Table fields but see no clue on how to do this....