record locked
Hello I have a problem with a locked record. How can I recognize the user and how can I solve the problem ? Thank you Andreas Lommel
Try this little script...
DATABASE sysmaster;
SELECT username name, pid, dbsname[1,10] database,
tabname[1,12] table, hostname, type
FROM syslocks, syssessions
WHERE syslocks.owner = syssessions.sid
ORDER BY 3,2
It produces a lot of output if you have a lot of users on the system but it
will identify who is using what. Modify the WHERE clause to check for
(X)clusive or (IX)clusive Intent on the 'type' field.
Alternatively, just do onstat -k and work your way through it !!
Sean
HIM Biebesheim wrote in message <7723n5$n5a$1@news07.btx.dtag.de>...
>Hello
>I have a problem with a locked record. How can I recognize the user and how
>can I solve the problem ?
>Thank you
>Andreas Lommel
>
>