Utility to find who's got a lock
> From: nvuong01@solix.fiu.edu (nathan n vuong)
> Subject: Utility to find who's got a lock
>
> I would appreciate some information on where I can find
> a utility that allows one to detect what users are locking
> which tables. The following describes the platform we're
> running:
>
> Informix S.E. 4.10
> SCO Unix 3.2
>
> Thanks,
> Joe C.
> Email:JCDives@aol.com
I don't remember about old SE versions, or know much about SCO Unix,
but here in the OnLine world on DEC Unix we use:
$ tbstat -k
RSAM Version 5.02.UC2 -- On-Line -- Up 57 days 01:59:05 -- 2240 KbytesLocks
address wtlist owner lklist type tblsnum rowid size
82493c 0 801f54 0 HDR+S 1000002 204 0
824984 0 80203c 0 S 1000002 204 0
[...]
25 active, 20000 total, 2048 hash buckets
$ tbstat -u
RSAM Version 5.02.UC2 -- On-Line -- Up 57 days 01:59:58 -- 2240 KbytesUsers
address flags pid user tty wait tout locks nreads nwrites
801bb4 ------D 205 root - 0 0 0 1729 25364
801c28 ------D 0 root - 0 0 0 0 0
801c9c ------F 206 root 0 0 0 0 0
801d10 ------F 207 root 0 0 0 0 0
801d84 ------F 208 root 0 0 0 0 0
801df8 --A---M 3659 informix - 0 0 0 0 0
801e6c ------- 14552 fstest tty19 0 0 1 52 0
[...]
31 active, 64 total
Transactions
address flags user locks log begin isolation retrys coordinator
8038b4 A---- 801bb4 0 0 NOTRANS 0
803edc A---- 801c28 0 0 NOTRANS 0
804504 A---- 801df8 0 0 COMMIT 0
[...]
28 active, 64 total
The explanations for these columns are in the OnLine Administrator's
Guide (which you don't have, I know). I don't know where in the SE
guide you might find these things. The more I write here the less
usefull it seems... ;)
Say "Larvae"!
__________________________________________________________________
| Clem Akins Standard Disclaimers Apply |
|Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" |
| Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com |
|________________________________________________________________|