Re: Information about tables in use?!
Mr Cheuk Kong Lo wrote:
>
> I'd like to know if there is a way to find out what tables are in use
> by a user (thread). Any possible of knowing what row is current in use
> by a user (thread) as well?
>
Onstat -g opn shows open tables by thread id. Onstat -k will show
locked rows/pages by rstcb which can be translated to thread id in
onstat -u. You cannot track rows which are not locked.
Art S. Kagel